Subtracting date fields in lotus notes

Question

I need to subtract two date fields in order to get the number of days as the difference. I tried subtracting them in the "Default Value" section of the Field. But the message Incorrect Data Type for operator or @function appears on the screen. The field was defined as an editable/number field.

Can you please advice on how to properly solve this problem using the @function in the "default value" section of the field property?

Thank you for kind help.

Answer 1

You can find the number of seconds between two dates by subtracting them. Then get the days by dividing by 86400 (seconds in a day). No @function is required.