Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

date format

Hi,

My current date format is  '06/28/2016' and the format required is '28-June,2016'

Thanks..

1 Solution

Accepted Solutions
PrashantSangle

Hi,

try date() and date#()

date(yourdateField,'DD-MMMM,YYYY')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

3 Replies
PrashantSangle

Hi,

try date() and date#()

date(yourdateField,'DD-MMMM,YYYY')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
PrashantSangle

or if it is not in date datatype then

date(date#(dateField,'MM/DD/YYYY'),'DD-MMMM,YYYY')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
MK_QSL
MVP
MVP

Front End

=Date(Date#('06/28/2016', 'MM/DD/YYYY'),'DD-MMMM-YYYY')

Back end

Date(Date#(YourOriginalDateField, 'MM/DD/YYYY'),'DD-MMMM-YYYY') as YourNewDateField

Kindly read below blogs which will help you to understand how to handle dates in QlikView

The Date Function

Get the Dates Right

Why don’t my dates work?

QlikView Date fields