Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this:
date(date#(report_date,'YYYYMMDD'),'MMM-YYYY') as monthyear
or this:
date(MonthStart(date#(report_date,'YYYYMMDD')),'MMM-YYYY') as monthyear