Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
nareshthavidishetty
Contributor III

date format

Hi,

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

Thanks..

Tags (1)
1 Solution

Accepted Solutions

Re: date format

Hi,

try date() and date#()

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

3 Replies

Re: date format

Hi,

try date() and date#()

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.

View solution in original post

Re: date format

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.
MVP
MVP

Re: date format

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