topic Re: '01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'? in QlikView

'01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'?

Amelia_96 — Wed, 25 Nov 2020 16:16:04 GMT

Hi, i have data with date '01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'? And i also need to filter this date but i cannot. Please help

Re: '01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'?

tresB — Wed, 04 Nov 2020 06:19:34 GMT

Date(Date#('01JAN2020:00:00:00', 'DDMMMYYYY:hh:mm:ss'), 'DD/MM/YYYY')

Re: '01JAN2020:00:00:00'. How do i change this date format to 'DD/MM/YYYY'?

Amelia_96 — Wed, 04 Nov 2020 06:25:03 GMT

Thank you so much!!