Pricing Docs Academy

Date functions

Iamasuperuser

4 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

4 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

4 months ago

Oh you gem! Many thanks indeed @needtheanswers !
needtheanswers

4 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

4 months ago

you are welcome 🙂
Iamasuperuser

4 months ago

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

4 months ago

Happy to hear that! Glad I could help 👍

Leave a comment

Stop scrolling. Start building.

toddle is a visual web app builder that rivals custom code — but accessible to your entire team!

Try toddle — it's free!

The two toddle Co-Founders Andreas and Kasper

Chat with @team-toddle

CEO and Co-Founder of toddle Andreas Møller

Video call our CEO

Hello, toddle!

Get in touch!

Product

Pricing Packages T&Cs Privacy Policy

Company

Press kit Contact
Become partner Refer and earn

Resources

Documentation Academy Integrations Blog Founder stories Hire experts

Community

Discord LinkedIn X YouTube

© Copyright 2024 toddle. All rights reserved.

Built in toddle