Today(2) in Load Editor

[#1]

Hi Everyone,

I would like to ask if Today(2) is used in data load editor to calculate certain fields. Would it recalculate the fields every time the app was open?  Or do I need to reload it every time?

[MK_QSL · Accepted solution]

Today() will work with below...

0 Date at script run

1 Date at function call

2 Date when the document was opened  

So if you want to get Today's date without reloading the app use...

=Today(1)

[#3]

Hi Manish, thanks for clearing my doubt.