Datefield MonthYear

[#1]

Hi,

I'm loading monthly data witht the below date format, however I would like to convert it to 'YYYY-MMM'

201501

201502

201503

I tried the below but it results in null values.

DATE(Date,'YYYY-MMM') as Month

[sunny_talwar · Accepted solution]

Try this:

Date(Date#(Date,'YYYYMM'),'YYYY-MMM') as Month