Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Hi Naveen, you an try with:

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

Or:

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

Highlighted
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')

Highlighted
Specialist
Specialist

Hi Naveen,

Try the below code

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


Thanks,

Venkata Sreekanth

Highlighted
Master
Master

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

Highlighted
Creator II
Creator II

Use Timestamp function:

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