Solved: Re: date format - Qlik Community

nareshthavidishetty · ‎2016-06-28

Hi,

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

Thanks..

PrashantSangle · ‎2016-06-28

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

PrashantSangle · ‎2016-06-28

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 · ‎2016-06-28

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 · ‎2016-06-28

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