I have an access query to record equipment casualty reports. There are initial dates and correct dates. I need to compute the number of days from initial date to today if the report is active, or compute the number of days from initial date to correct date if the report is closed. Below is my attempt but I am getting an invalid syntax error:
IIf([Correct Date] IsNull, (DateDiff('d', [Initial Date],Date()), (DateDiff('d'[Initial Date], [Correct Date])
What am I doing wrong?:banghead:
IIf([Correct Date] IsNull, (DateDiff('d', [Initial Date],Date()), (DateDiff('d'[Initial Date], [Correct Date])
What am I doing wrong?:banghead: