Returns the system date and time as a type Date.
Fernando Na
Wed, 08/31/2022 - 10:15
Permalink
Hi Brian! Is it posible to sum dates to this function? Something like this: now() - 5 Should be 26/08/2022
Brian Element
Wed, 08/31/2022 - 11:59
You would have to do something like this for that to work:
DateSerial(Year(Now()), Month(Now()), Day(Now()) - 5)
Thu, 09/01/2022 - 08:18
It works perfectly that way
Import
Explore
Relate
Extract
IDEAScripting
Custom Functions
Continous Monitoring
Effective Analytics
Benford's Analysis
Smart Analyzer
IDEA Help Videos
IDEA Related Videos
IDEA Success Stories
Forum List
Comments
Fernando Na
Wed, 08/31/2022 - 10:15
Permalink
Sum or Rest days to this function
Hi Brian! Is it posible to sum dates to this function? Something like this: now() - 5 Should be 26/08/2022
Brian Element
Wed, 08/31/2022 - 11:59
Permalink
You would have to do
You would have to do something like this for that to work:
DateSerial(Year(Now()), Month(Now()), Day(Now()) - 5)
Fernando Na
Thu, 09/01/2022 - 08:18
Permalink
Thanks a lot Brian
It works perfectly that way