Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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

View solution in original post

5 Replies
kji
Employee
Employee

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

teempi
Partner - Creator II
Partner - Creator II

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

-Teemu

Not applicable
Author

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
Author

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
Author

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