Date functions

Iamasuperuser

5 months ago

Hi! I've discovered the NOW formula to get todays date. But is it possible to say something like "Now minus 7 days"?
The AI bot says to use the AddDays -7 function, but that seems to be a hallucination, as AddDays doesn't exist. Neither does Offset or any other date manipulation formula. Would anyone know how I can add and remove dates from a date in order to show that variable in a Date Input field.
Thanks
needtheanswers

5 months ago

Lol I had the same issue a few days ago and got confused as well by the "AddDays" response of the AI bot. I figured it out and you need to do it like this:
Maybe there is a better way to do it but this works
Iamasuperuser

5 months ago

Oh you gem! Many thanks indeed @needtheanswers !
needtheanswers

5 months ago

mind that I wanted to get yesterdays date in the screenshot so in your case it would be 86400000*7. Just calculate the ms
🔥1
@Iamasuperuser
Oh you gem! Many thanks indeed @needtheanswers !
needtheanswers

5 months ago

you are welcome 🙂
Iamasuperuser

5 months ago

and that worked. Thanks so much. Very much appreciated.
@Iamasuperuser
and that worked. Thanks so much. Very much appreciated.
needtheanswers

5 months ago

Happy to hear that! Glad I could help 👍