Todays date minus date in past

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.

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

So what is the problem?

1 Like

It doesnt work.

image

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

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.

Hope this helps. Happy bubbling. :v:

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

1 Like

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).

1 Like

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