topic Re: Date conversion on Qlikview in QlikView

Date conversion on Qlikview

Sun, 13 Dec 2015 11:11:30 GMT

Good day,

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

Regards,

Mbini

maxgro — Sun, 13 Dec 2015 16:30:25 GMT

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

marcus_sommer — Sun, 13 Dec 2015 16:31:54 GMT

If it's already a date then:

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

- Marcus

MarcoWedel — Sun, 13 Dec 2015 22:50:02 GMT

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

Mon, 14 Dec 2015 06:21:07 GMT

Thanks a lot Gentlemen, you saved my day

Anonymous — Mon, 14 Dec 2015 06:40:03 GMT

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 — Wed, 16 Dec 2015 00:07:05 GMT

you're welcome

please close your thread by selecting a correct answer.

thanks

regards

Marco