Convert date to number

[VD]

Hi, 

I am converting todays date to number like, 20210917.

but my code giving me 20220905.

below is my code,

Year(DateValue(Text( Now(), "dd/mm/yyyy" ))) * 10000
+ Month(DateValue(Text( Now(), "dd/mm/yyyy" )))
+ Day(DateValue(Text( Now(), "dd/mm/yyyy" )))* 100

what is wrong in above code?

[Cooper01]

Think you're looking for the text function

Text(Today(), "yyyymmdd")

[zmansuri · Accepted solution]

[VD]

Thanks, it's working as expected.

[zmansuri]

Glad to help