Date differences

HCL Domino Domino Forum
1

I have a EDate and I want to calclate the difference between today and edate.

In my Expire filed I have the following forumula which calculates it correctly

Expire Filed Formula which is ; Computed Date/Time

(@Date(@Today) - @Date(Edate) ) / 86400 ;

When I go to create a new document I get

Field 'Expire" : Incorrect data taype for operate or @function Time/Date Expected.

In the long run what I am trying to do is have a view that only shows the expired documents so that I can set up an agent to e-mail IT To Take away Access because the time has expired.

2

Subject: date differences

Your Expire field needs to be numeric, not Time/Date as the formula resolves to a number, not a date.

You will probably need to add a line to check that the Edate field is not blank, as that will cause the error when you open a new document.

Hope this helps,

Phil