Date math....

[rlaliberte]

Is there anyway to math with dates for insertion into a variable?

Such as for reports that are run today, but need to be run FOR yesterday?

[forumsupport]

Hello,

Definitely yes. You can get date-1 by using =today()-1 function in excel, copy using CTRL+c and assign it to some variable and use it in your task.

What you can do is as follows:

Go to cell A1 in excel file, and write =today()-1 and hit Enter.
Now hit UP Arrow key and CTRL+C to copy the value.
Assign $Clipboard$ value to some variable.
Now use this variable in your task.

Hope that helps.