How to get a return of a month-day column from a year-month-day column?

[petercreateParticipant]

I checked the function reference. There are only separate day, month, year functions.

[dgteamModerator]

You can use the ICU format to specify the display format.  Hover over the entry box to get a list of common format stings.  Does that help?

[petercreateParticipant]

Thanks. My intent was to only keep the value of month and day but excluding year, not just not showing the complete date. I have columns of daily data from some year to another and want to compare them between years. So I need put the daily values in lines from day 1 to day 365 and repeat them with different-year data above the same x-axis. I put an example below. Sorry, they are in hours 🙂

[dgteamModerator]

See if this helps ….

You can use the month( ) and day( ) functions in separate columns and then combine them using a Text Expression column.

Here is the plot with Day of Year as the x-axis.

The same graph with the x-tick mark labels set in the Axis settings to the month-day.

Hope this helps!

 

[Author]

Posts