Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
potti222
Contributor
Contributor

Change Date format

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

5 Replies
rubenmarin

Hi Naveen, you an try with:

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

Or:

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

qlikviewwizard
Master II
Master II

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

or

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

Anonymous
Not applicable

Hi Naveen,

Try the below code

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


Thanks,

Venkata Sreekanth

shiveshsingh
Master
Master

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

khanashique
Creator II
Creator II

Use Timestamp function:

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