Change Date format

[potti222]

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]

Hi Naveen, you an try with:

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

Or:

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

[qlikviewwizard]

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

or

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

[Anonymous]

Hi Naveen,

Try the below code

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

Thanks,

Venkata Sreekanth

[shiveshsingh]

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

[khanashique]

Use Timestamp function:

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