Date Format

[#1]

Hi There

Please help.

At the moment, I am using NUM(month(Today())) to get today's month (11 - which is Nov). however, NUM(month(Today()))-2 will give me Sep (9). How can I convert '9' to '09' as the data from my extract is expecting 09 and not 9.

Thanks

[kji]

Num(NUM(month(Today()))-2,'00')

[teempi]

You can also try Date(Today(), 'MM').

-Teemu

[#4]

Hi

This seem to work but for some reason when I use Month(today()) it says 11 instead of 12. Do you have an idea?

thanks

[#5]

Hi

This seem to work but for some reason when I use Month(today()) it says 11 instead of 12. Do you have an idea?

Thanks

[#6 · Accepted solution]

=NUM(Month(today(1))) seem to have done the trick for

"This seem to work but for some reason when I use Month(today()) it says 11 instead of 12. Do you have an idea?"