how to change a date format 20181010 to month year Oct-2018?

[jim_chan]

Hi guys,

How to change a date format 20181010 to month year Oct-2018?

I have a date field data - 20181010, in the backend script i use:date(MonthStart(date#(report_date,'yyyymmmdd')),'MMM-YYYY') as monthyear.

result was - Jan-2018, but why is it not Oct-2018??

Please help guys!

Rgds

Jim

[Frank_Hartmann]

try this:

date(date#(report_date,'YYYYMMDD'),'MMM-YYYY') as monthyear

or this:

date(MonthStart(date#(report_date,'YYYYMMDD')),'MMM-YYYY') as monthyear