Converting Date to MonthYear

[Bob07]

Hi,

I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you. 

LOAD
"Submission Date",
date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,

Submission Date	customer	Amount	Expected
30/01/2022 14:10	John Doe	23	Jan-22
01/08/2023 16:15	John Doe	56	Aug-23
02/07/2021 08:31	John Doe	42	Jul-21
02/03/2024 10:34	John Doe	87	Mar-24
02/06/2024 16:19	John Doe	26	Jun-24

[Enno86 · Accepted solution]

Hi @Bob07 ,

you could also just use "MonthName(date#([Submission Date])"

This will give you the name of the Month as well.

Furthermore in the x-Axis definition, you need to deactivate the "continous" option. Then your dates should be all populated on one spot per each month.

[BrunPierre]

Try

Date(Floor(TimeStamp#([Submission Date] 'DD/MM/YYYY hh:mm')), 'MMM-YYYY')

[Bob07]

Thank you. It worked when I deactivated the continuous option.