0

Current date at report runtime

Jet Reports Historic Posts

April 04, 2013 08:11

None

Follow

Hi,

Perhaps I'm blind but I can't find a way to set a date which is pulled/calculated only when the report runs.
Excel (Today()) doesn't help in that case as it is refreshed each time the file is opened or recalculated.

Any idea?


Cheers
André

• Facebook
• Twitter
• LinkedIn

4 comments

• 
  Jet Reports Historic Posts April 04, 2013 08:53 Official comment

  Does Cell A1 have "Auto+Hide+Values" in it?
  Did you run the report, save it and reopen it again? I.e. not in Design mode.

• 0
  
  Jet Reports Historic Posts April 04, 2013 08:35

  Hi André,
  
  This should do the trick: =NP("Eval";"=TODAY()"). Does it work for you?

• 0
  
  Jet Reports Historic Posts April 04, 2013 08:47

  Hi Hans,
  
  As far as I can see =NP("Eval";"=TODAY()") is also recalculated when you open the Excel file.
  
  Cheers
  André

• 0
  
  Jet Reports Historic Posts April 04, 2013 09:13

  Does Cell A1 have "Auto+Hide+Values" in it?

  
  It seems THAT is the solution as I usually don't use "+Values" (up to now 8-) ).
  I just tried it with a timestamp and it works. So I guess the datestamp will work as well tomorrow.
  
  Thank you very much.
  
  Cheers
  André