How to get double from date?

DangDKhanh-2637 946

Hi,
I have the following numbers:

int d=21, m=1, y=2022, h=0,m=0,s=0

I can convert them to string with format as datetime "2022/1/21 00:00:00", then convert to double by code from this post

but this result=1642698000 is different from excel 44582.

Can I achieve this without MFC?
Thanks you.

Accepted answer

RLWA32 43,306 Reputation points

2022-01-21T16:29:42.82+00:00

Try this function -- VarDateFromStr
Please sign in to rate this answer.
DangDKhanh-2637 946 Reputation points

2022-01-21T16:37:29.36+00:00

Hi @RLWA32
Great. this works as i expected !!!
Thanks for saving me time.

RLWA32 43,306 Reputation points

2022-01-21T16:39:45.723+00:00

You're welcome. :)

Viorel 114.7K Reputation points

2022-01-21T17:10:35.74+00:00

If you are interested, maybe you will find a way to avoid the intermediate strings.

RLWA32 43,306 Reputation points

2022-01-21T17:44:51.56+00:00

If you would like to avoid the intermediate string as @Viorel suggests you can use SystemTimeToVariantTime
Sign in to comment

0 additional answers