Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Date Format

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

1 Solution

Accepted Solutions
Not applicable

Re: Date Format

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

5 Replies
Employee
Employee

Date Format

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

teempi
Contributor II

Date Format

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

-Teemu

Not applicable

Re: Date Format

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

Not applicable

Re: Date Format

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

Not applicable

Re: Date Format

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

Community Browser