Date field to Month Year field

[drohm002]

Hello, I am trying to get a Month-Year field from SCHEDULEDDTM, see below.  An example of the format for SCHEDULEDDTTM is   2022-01-01 00:00:00.000000

I am only able to get the first row to display correctly:

My code to get this is:

date(monthstart(SCHEDULEDDTTM), 'MMM-YYYY') as SCHEDULED_YEAR_MONTH

How do I achieve this?  Please help, thank you!

[Vegar · Accepted solution]

It looks quite ok to me, i would expect it to work.

Try beeing more explicit,  maybe  do this adjustment. 

Monthname(timestamp#(SCHEDULEDDTTM,'YYYY-MM-DD hh:mm:ss.fff') as SCHEDULED_YEAR_MONTH