Todays date minus date in past

benjamin.bm.andrews · 2024-07-26T20:41:49.090Z

I want to do an equation where it works out how many days between the last entered date in the DB and the date selected on the form. I cant work out how to create the equation, nothing I try comes up blue.

adamhholmes · 2024-07-26T21:43:47.934Z

Well… you’ve already answer the question in the post title… (i.e. current-date minus past-date)

So what is the problem?

benjamin.bm.andrews · 2024-07-27T02:13:21.621Z

It doesnt work.

Ive tried it with value instead of date value as well.

bestbubbledev · 2024-07-27T05:29:38.524Z

I just tried it in my editor as well. The reason it shows an issue is that the data in the text box must be a text while value in your case it is a date interval. So at the end of the expression click more and format the value as number of days/hours/etc.

Screenshot 2024-07-27 at 9.26.02 AM764×792 170 KB

Hope this helps. Happy bubbling.

benjamin.bm.andrews · 2024-07-27T06:54:38.227Z

Cheers mate, I had the input field as date, I would never have thought it needed to be text.

georgecollier · 2024-07-27T07:18:48.771Z

Dates are actually numbers, measured in seconds since January 1st 1970 (search Unix timestamp for more info)

Right now, it is 1722064591. 24 hours ago it was 1721949391.

So, Current date - yesterday’s date = 1722064591 - 1721978191 = 86,400 seconds. :formatted as days will divide this by 3,600 to get the value in days (86,400/3,600 = 1).

system · 2024-10-04T20:42:46.768Z

This topic was automatically closed after 70 days. New replies are no longer allowed.