0

Print Data Date

John Maltman

February 26, 2021 08:20

None

Follow

Hi all,

I am looking to be able to print when the data was last refresed. For example a line in the header of the report saying:

Data last refreshed at 26/02/21 08:30 

or something like that. I know I can do it via VBA, but I would like to avoid it if possible.

Thanks,

John.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Bryan Robinson March 04, 2021 14:26

  If you put the NOW() function in an NP("Eval") it will only change the date at run time.  You will then need to format correctly to show date/time and append it to the text you want.

• 0
  
  John Maltman March 04, 2021 14:32

  Brilliant, hadn't thought about that option!!

   

  Appreciate it Bryan!