1

Show the date of the latest refresh

Annabel

September 20, 2017 13:06

Answered

Follow

Hi all, 

 

Is there a formula in JET which will show you the date and time of the latest update of the data? I would like to add this in my Excel-files, as you can easily check how up to date the data is that you're using. 

Thanks for your help!

 

 

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Heather Rowe September 20, 2017 13:14

  for my reports - it's the date that matters, but this solution will work for date/time as well

  I'm assuming that your report has the +Values code in cell A1

  Anywhere at the top of the report (in the visual area of the report) - you input this formula:

  =NOW()*NL(,NP("INTEGERS",1,1)) - then format the cell to show date/time

  The NL formula means that you are multiplying the "now" time by 1 - but since it is a Jet formula, that will turn the "NOW" into a static time when the report runs - it won't update when the file is opened.  But when you refresh the report, it will update.

• 0
  
  Annabel September 20, 2017 14:05

  Hi Heather, 

   

  Thanks a lot for your help! The formula is working indeed!

• 0
  
  Heather Rowe September 20, 2017 14:30

  always happy to help :)