Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

Issue with Date format

Hi All,

I am trying to convert the Date from 'DD/MM/YYYY' to 'DD MMM YYYY'.

My date here  is 9/1/2017 (DD/MM/YYYY), when I try to convert to 'DD MMM YYYY', I get '01 Sep 2017' instead of '09 Jan 2017'. If I have 31/1/2-017 I don't see any date when I use 'Monthname' function.

Did anyone come across this kind of scenario?

Thanks in advance!

Cheers,

Varun

1 Solution

Accepted Solutions
el_aprendiz111
Specialist
Specialist

Hi:

1 Example:

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

View solution in original post

6 Replies
krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Change the Default Date format as below

SET DateFormat='D/M/YYYY'; 

LET vDate = Date('9/1/2017','DD MMM YYYY');

el_aprendiz111
Specialist
Specialist

Hi:

1 Example:

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

varunreddy
Creator III
Creator III
Author

Hi fer,

Thanks for the quick response. It worked. What was the issue?

Cheers,

VK

varunreddy
Creator III
Creator III
Author

Hi Krishna Priya,

Thanks for your quick response. It is still showing the same issue.

Cheers,

VK

Chanty4u
MVP
MVP

Hi,

Try below

=Date(Date#(Datefield, D/MM/YYYY'),'DD/MMM/YYYY')  as newdate

Not applicable

Hi Varun,

Whenever you need to change date from one format to another than better use Date# function.

=Date(Date#('9/1/2017','D/MM/YYYY'),'DD/MMM/YYYY')

Regards

Deepak