Good Day
I am hoping that there is an Access expert that can please help me with a formula.
I have create a query and managed to work out the number of days difference between 2 dates. I would however like to take it one step further ...
I have a field called "VAFStatus"
What I want to do is to work out the number of days between TODAYS date and the date the record was captured (VAFDate)
BUT ...
When the option "Filled" from the VAFStatus dropdown field is selected the number of days should be worked out between "VAFDate" & VAFDateFilled" (2 date fields)
My formula I would use in excel looks like this:
=IF(C1="Filled",DAYS(B1,A1),DAYS(NOW(),A1))
Thank you in advanced!