Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert String to Date

Hello,

I have the following Date as a String:

01/08/2016 03:00 (DD/MM/YYYY hh:mm)

What I need is to convert it to Date in order to show the month like this: August

Do you know how to do that?

Thank you!

2 Replies
trdandamudi
Master II
Master II

May be as below:

Date_Conversion.jpg

sunny_talwar

May be like this:

Date(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Date,

Month(Date#(DateField, 'DD/MM/YYYY hh:mm')) as Month,

Date(MakeDate(Year(Today()), Num(Month(Date#(DateField, 'DD/MM/YYYY hh:mm'))), 1), 'MMMM') as FullMonthName