topic Re: Change Date format in QlikView

Change Date format

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

Hi all,

i have a date field like below

CreatedDate

20-02-2018

i want to change the format to 20/Feb/2018

how to change this ? can anyone help on this?

thanks

Nave

rubenmarin — Sun, 25 Mar 2018 18:37:11 GMT

Hi Naveen, you an try with:

Date(CreatedDate, 'DD/MMM/YYYY')

Or:

Date(Date#(CreatedDate, 'DD-MM-YYYY'), 'DD/MMM/YYYY')

qlikviewwizard — Mon, 26 Mar 2018 07:57:27 GMT

=DATE(DATE#('20-02-2018','DD-MM-YYYY'),'DD/MMM/YYYY')

=DATE(DATE#(CreatedDate,'DD-MM-YYYY'),'DD/MMM/YYYY')

Anonymous — Mon, 26 Mar 2018 08:00:01 GMT

Hi Naveen,

Try the below code

Date(Date#(CreatedDate, 'DD-MM-YYYY'), 'DD/MMM/YYYY')

Thanks,

Venkata Sreekanth

shiveshsingh — Mon, 26 Mar 2018 08:32:56 GMT

Date(Date#(CreatedDate, 'DD-MM-YYYY'), 'DD/MMM/YYYY')

khanashique — Mon, 26 Mar 2018 12:04:30 GMT

Use Timestamp function:

timestamp(CreatedDate, 'DD/MMM/YYYY')