Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=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?"
Num(NUM(month(Today()))-2,'00')
You can also try Date(Today(), 'MM').
-Teemu
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
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
=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?"