Date operations using Evan Balster's formula macro

[Hubert]

I'm having problems getting this right. Evan's <<formula>> documentation shows the following syntax to add days to a date:

add_days(d1,n)

But when I attempt this...

<<formula "add_days('20180622', 5)">>

...I get the following error:

ComputeError: Cannot auto-convert "20180622" to a date!




What exactly am I doing wrong?




Thank you for your help!




Regards,


Hubert




[Mark S.]

This seems to sort of work:

<<formula "add_days(tw_date('20180622'), 5)">>

This converts your almost-TW date into an addable date before the addition.

In my timezone, the result if off by one day (06-26). I think it's because you're not specifying the hour, minutes, seconds. So, your results may vary.

-- Mark

[Hubert]

Thank you very much!!