HI Guys,
A nice easy one for someone.
We auto generate a set of reports that requires the system date to be passed to a formula, so that a "Gas Day" (06:00-06:00) can be calculated.
The formula allows the data to be reported-on for the previous "Gas Day". The reports auto generates (Scheduled) each morning.
All is well until you attempt to look at the reports historically! We use the current date minus one in the report, to show the Gas day, that's fine if you look at it that day! However if you look at it a day or two later you get the current day minus one, not the date the report was generated.
Can any one suggest a function that stores the date(Minus one) the report was run?
Regards
Tartanman
A nice easy one for someone.
We auto generate a set of reports that requires the system date to be passed to a formula, so that a "Gas Day" (06:00-06:00) can be calculated.
The formula allows the data to be reported-on for the previous "Gas Day". The reports auto generates (Scheduled) each morning.
All is well until you attempt to look at the reports historically! We use the current date minus one in the report, to show the Gas day, that's fine if you look at it that day! However if you look at it a day or two later you get the current day minus one, not the date the report was generated.
Can any one suggest a function that stores the date(Minus one) the report was run?
Regards
Tartanman