532651_en-US

liliconcom

Insert Today date in Graph Title automatically using script

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:

 

 

ScriptingRe: Insert Today date in Graph Title automatically using script

There are a couple of issues.

1. The & is not the concatenation syntax.  two vertical bars is what is used    ||
2. 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 )

Re: Insert Today date in Graph Title automatically using script

Splendid !

Thanks, it solved the problem.

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