topic Convert String to Date in QlikView

Convert String to Date

Wed, 25 Nov 2020 16:16:04 GMT

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!

trdandamudi — Mon, 26 Sep 2016 16:07:35 GMT

May be as below:

sunny_talwar — Mon, 26 Sep 2016 16:11:37 GMT

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