topic Converting string to date in QlikView

Converting string to date

varunreddy — Mon, 18 Apr 2016 14:56:06 GMT

Hi Guys,

I have created a MonthYear field combining Month and Year

Month(Date) & '-' & Year (Date) as MonthYear.

Now this is displaying in string format. I want to convert this to date format and I want to calculate maximum date using MonthYear field.

Can anyone guide me?

Thanks in advance!

Regards,

Varun

sunny_talwar — Mon, 18 Apr 2016 14:58:00 GMT

Try this:

Date(Date, 'MMM YYYY') as MonthYear

MonthName(Date) as MonthYear

varunreddy — Mon, 18 Apr 2016 15:04:37 GMT

Thanks Sunny