topic Re: Insert Today date in Graph Title automatically using script in Discussions

Insert Today date in Graph Title automatically using script

WebDesignesCrow — Fri, 09 Jun 2023 17:07:20 GMT

Hi,

I want to insert today date in Graph title.

The script run daily, so I want the title date change with run date.

I add script below but it didn't work.

Any idea how to insert today date in the graph title?

SendToReport(
		Dispatch(
			{},
			"Distributions",
			OutlineBox,
			{Set Title( "Distributions of last 30 days as of" & Today() )}

The log:

txnelson — Thu, 11 Aug 2022 01:53:36 GMT

There are a couple of issues.

The & is not the concatenation syntax. two vertical bars is what is used ||
The Today() function does not return a string, it return a numeric value, which is the number of seconds since Jan 1, 1904. You need to use a Format() function to convert the Today() function. Format(today(),"m/d/y", 10 )

WebDesignesCrow — Thu, 11 Aug 2022 02:31:30 GMT

Splendid !

Thanks, it solved the problem.

Dispatch(
			{},
			"Distributions",
			OutlineBox,
			{Set Title( "Distributions for last 30 days as of " || format(today(),"d/m/y",10); )}
		),