I have a date in the past in my database (3/10/2020) for example and I want to calculate the number of days until I get to the next day/month. So if today is 3/3/2025 I want my formula to return 7. If today was 3/11/2025, I want my formula to return 364. Can I get some help on how to do this please?
Hi @ishuster86,
Internally Adalo stores date and datetime properties as a number of days since 1/1/1970.
So to get the days difference you can simply make a deduction between 2 days.
You need to be cautions when you use datetime, as it contains the hours as well.
Just in case, this question has been discussed in the forum quite frequently and there are quite a lot of useful posts.
Best,
Victor.
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.