Date Formatting on Combo Chart

[bskemp01]

Ok folks i need some help if possible. I am looking for a way to format Dates as Month & Day only. i.e. - (Jan-1, Jan-2, etc). I have yet to find a forum post about this so any help would be appreciated. I have tried this:

Date(MakeDate(num(SFINVY)+2000,left(num(SFINVM,'0000'),2),right(num(SFINVM,'0000'),2)),'MM-DD') as DayOfYear

*SFINVY is a two digit year from the database.

*SFINVM is the month and day (Jan 21 = '121') from the database.

and as you can see here the value is being formatted correctly:

but the format still comes out as 1/1/2024 on the chart. (See screenshot below)

The Reason: the reason i need the dates in this format is because i have a combo chart that i have multiple lines on, some for current year and some for previous and i need them to overlap based on the day of the year(for any year).

What i am getting:

What i need:

[theoat · Accepted solution]

Change the line SET DateFormat like this :
SET DateFormat = 'MMM-D';

Kind regards,
Théo ATRAGIE.

[bskemp01]

this changes the formatting correctly. finally have something that works. thank you!!