topic Re: date format in QlikView

date format

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Thanks..

PrashantSangle — Tue, 28 Jun 2016 08:03:09 GMT

Hi,

try date() and date#()

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

Regards

PrashantSangle — Tue, 28 Jun 2016 08:05:37 GMT

or if it is not in date datatype then

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

Regards

MK_QSL — Tue, 28 Jun 2016 08:19:38 GMT

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