Discussion Board for collaboration related to QlikView App Development.
I have a date field in the format DDMMMYYYY and in addition to the standard date information that I am extract from that field (i.e. month name, week commencing etc) I want create a field with the month number.
So the date of '01APR2015' should give me 4.
Any help appreciated.
=date(date#( '01APR2015' ,'DDMMMYYYY'),'M')
=num(month(date#( '01APR2015' ,'DDMMMYYYY')))
Fantastic, thank you!
Brilliant, Thank you
Your solution does not return the month number. It runs the same date with a display format of "M".
=date(date#( '14APR2015' ,'DDMMMYYYY'),'M')
would create two rows in a listbox or chart which is probably not what the poster wants.