We use cookies to ensure that we give you the best experience on our website. Click here for more information. Got it
Hi,
Please help me to get add formula in date.
Example - I want tomorrow date formula is (Today +1)
RESOURCES
Copyright © 2025 Justinmind
Footer policies
Footer policies
Footer policies
Hi there,
This is a little complicated, because natively we don’t have this functionality. However, you can do it manually using events and expressions.
To start, you need to split the current date into month, day and year using the substring method in expressions and save these values into variables.
Then, you need to add one day to the “day” variable using a set value event, and then check if the resulting value is still valid as a date (we don’t want a 32-day month!).
If it is the case, you need to set up another set value event to set the day to “1” and add 1 to the month value. And do the same for years.
At last, once the calculations are done, you need to add a final set value event to concatenate all variables into a date format (MM/DD/YYYY).
Hope this helps.
Best,
Danielle
Hi there,
This is a little complicated, because natively we don’t have this functionality. However, you can do it manually using events and expressions.
To start, you need to split the current date into month, day and year using the substring method in expressions and save these values into variables.
Then, you need to add one day to the “day” variable using a set value event, and then check if the resulting value is still valid as a date (we don’t want a 32-day month!).
If it is the case, you need to set up another set value event to set the day to “1” and add 1 to the month value. And do the same for years.
At last, once the calculations are done, you need to add a final set value event to concatenate all variables into a date format (MM/DD/YYYY).
Hope this helps.
Best,
Danielle
Replies have been locked on this page!