Subtract a day from a date

ortizmario6025…

Forums

Hello everyone.
I have a date in IDEA format of the form YYYYMMDD, how do I remain one day from that date?
Example
20211210 and I get 20211209, and place the result of the other date in a field and then make a join  by dates
thanks for your help
 

klmi Wed, 12/22/2021 - 04:21

You can do that with the following IDEA functions: @daystod(@dtodays(DATE) - 1)
BTW: @functions can be used in IDEAScript by replacing @ with i - so from @daystod becomes idaystod

ortizmario6025… Wed, 12/22/2021 - 09:42

month and years elapsed between two dates?
2021-10-20 - 2018-09-30 =? Years
2021-10-20 - 2018-09-30 =? month