Date conversion on Qlikview

[#1]

Good day,

Could you pleas assist in converting date with the following format 'DDMMMYYYY' to 'YYYYMMDD.

Regards,

Mbini

[maxgro]

date( date#( yourdatefield, 'DDMMMYYYY'), 'YYYYMMDD')

[marcus_sommer]

If it's already a date then:

date(YourDate, 'YYYYMMDD') and if not then: date(date#(YourDate, 'DDMMMYYYY'), 'YYYYMMDD')

- Marcus

[MarcoWedel]

Hi,

maybe helpful:

you might have to adjust your MonthNames variable to your short month names as well:

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

regards

Marco

[#5]

Thanks a lot Gentlemen, you saved my day

[Anonymous]

You can define the format at script level in main tab...see the attachment.

If it is does not work, use date() & date#()(If Required) as suggested by Marcus

[MarcoWedel]

you're welcome

please close your thread by selecting a correct answer.

thanks

regards

Marco