Converting string to date

[varunreddy]

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 · Accepted solution]

Try this:

Date(Date, 'MMM YYYY') as MonthYear

or

MonthName(Date) as MonthYear

[varunreddy]

Thanks Sunny