topic Date Format in QlikView

Date Format

Thu, 01 Dec 2011 11:46:32 GMT

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

Date Format

kji — Thu, 01 Dec 2011 11:52:14 GMT

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

Date Format

teempi — Thu, 01 Dec 2011 12:00:40 GMT

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

-Teemu

Re: Date Format

Thu, 01 Dec 2011 15:02:06 GMT

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

Re: Date Format

Thu, 01 Dec 2011 15:02:43 GMT

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

Re: Date Format

Thu, 01 Dec 2011 15:38:30 GMT

=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?"