I have created a form wherein I set up the following dates:
Text119 (current date) formula used is =Date()
Submit date box - set up as date entered by the user
Deadline date - set us as date entered by the user
If the submit date box is empty, the difference will be [deadline date]-[text119]
if the submit date box is not empty, the difference will be 0, the formula set up for the difference is as shown below:
=IIf(IsNull([submit]),[DeadlineDate]-[text119],0)
the result showing is an error #NAME?
however, earlier it was showing the correct difference.
can anybody assist me on this.