Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Date format change?

Hi I have one date column year in my excel data

like

Apr 2014

June 2014

July 2014

Now i want to cnvert this into date format  like  Apr-2014

  please help me on that.

6 Replies
Highlighted
Partner
Partner

Date(MonthYear,'MMM-YYYY')

Highlighted
MVP
MVP

If your this date field is not a proper date field, you might have to try like:

Date(Date#(YourDateField, 'MMM YYYY'), 'MMM-YYYY') as NewDate

And yes, now I note that your date format is not uniform, somewhere three-letters;somewhere four-letters for month. They are expected to be uniform with three-letters.

Highlighted

Hi,


try below

Date#(MonthYear,'MMM-YYYY')

or

Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')


Regards

ASHFAQ

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Try like this

=Date(Date#(DateFieldName, 'MMM YYYY'), 'MMM-YYYY')

Regards,

Jagan.

Highlighted
Not applicable

Hi ,

iam not getting any data as per your expresson

actually the data is not in date format.

first i need to change

Jan 2014

Apr 2014

above data into date format

is there any way to change above data into date format

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Date() and Date#() function to convert the date format, refer my previous post for solution.

Regards,

Jagan.