Calculating the number of days between today and the date in a field

Support
1

How do I autmoatically calculate the number of days between today’s date and the day in the last modified field?
I have tried “Today() - E3” and “TodayTZ() - E3” but get nothing in the field.

2

Hi,

You may apply TODAYTZ()-E3 on a numeric field to get the result.

Please note that if you want to apply newly added formulas to existing records, you’ll need to manually trigger the formulas recalculation for the first time.

3

Doesnt work.
E3 is a date field - do I need to format it in some way to make the calculation produce a number?

4

Hi,

Please share a screenshot of your form design for us to refer to.

5

Screen Shot 2020-11-11 at 11.30.16
Screen Shot 2020-11-11 at 11.30.162446×800 59.7 KB

6

Hi,

We’ll need to have the screenshot of the design mode in order to know your field settings and the formulas configuration.

7

Screen Shot 2020-11-11 at 12.25.31
Screen Shot 2020-11-11 at 12.25.313132×842 287 KB

8

The formulas in case sensitive, so it should be written as “TODAYTZ()”.

9

This just does not seem to update. When I come back to a record the calculation is days old. Why won’t it recalculate?

10

Hi,

Please apply daily recalculation to have the formulas calculated on daily basis.

11

Can I test it - or do I have to wait for the job schedule to run?
The path to my database looks nothing like this.

12

Hi,

Sure, you may access the Job Schedule and trigger the daily workflow to test.