topic Re: Date Formatting on Combo Chart in Data Movement & Streaming

Date Formatting on Combo Chart

bskemp01 — Wed, 19 Mar 2025 22:11:20 GMT

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:

Re: Date Formatting on Combo Chart

theoat — Wed, 21 Feb 2024 14:02:40 GMT

Can you show me your main in the script ?
I think you will need to change this to resolve your case.

Kind regards,
Théo ATRAGIE.

Re: Date Formatting on Combo Chart

bskemp01 — Wed, 21 Feb 2024 14:05:29 GMT

This is the main in the load script if that is what you mean:

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Re: Date Formatting on Combo Chart

bskemp01 — Wed, 21 Feb 2024 14:08:29 GMT

is this what you are asking for?

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';
SET FirstWeekDay=6;
SET BrokenWeeks=1;
SET ReferenceDay=0;
SET FirstMonthOfYear=1;
SET CollationLocale='en-US';
SET CreateSearchIndexOnReload=1;
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';
SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';
SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Re: Date Formatting on Combo Chart

bskemp01 — Wed, 21 Feb 2024 14:11:48 GMT

SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;-$#,##0.00'; SET TimeFormat='h:mm:ss TT'; SET DateFormat='M/D/YYYY'; SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'; SET FirstWeekDay=6; SET BrokenWeeks=1; SET ReferenceDay=0; SET FirstMonthOfYear=1; SET CollationLocale='en-US'; SET CreateSearchIndexOnReload=1; SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'; SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December'; SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'; SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'; SET NumericalAbbreviation='3:k;6:M;9:G;12:T;15:P;18:E;21:Z;24:Y;-3:m;-6:μ;-9:n;-12:p;-15:f;-18:a;-21:z;-24:y';

Re: Date Formatting on Combo Chart

bskemp01 — Wed, 21 Feb 2024 14:14:14 GMT

are my replies coming through? everytime i refresh the page my reply is gone.

Re: Date Formatting on Combo Chart

bskemp01 — Wed, 21 Feb 2024 14:18:19 GMT

apparently trying to post code makes my reply disappear so heres a screenshot:

Re: Date Formatting on Combo Chart

Bolijay00 — Wed, 21 Feb 2024 14:27:20 GMT

try this Date(your date field, 'MMM-D')

Re: Date Formatting on Combo Chart

Bolijay00 — Wed, 21 Feb 2024 14:29:52 GMT

this will deninately work - Date(your date field, 'MMM-D')

Re: Date Formatting on Combo Chart

theoat — Wed, 21 Feb 2024 14:57:49 GMT

Bad idea, this isn't a good practice to use calculated dimension.

Re: Date Formatting on Combo Chart

theoat — Wed, 21 Feb 2024 14:59:25 GMT

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

Kind regards,
Théo ATRAGIE.

Re: Date Formatting on Combo Chart

bskemp01 — Thu, 22 Feb 2024 14:02:28 GMT

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