I am created a calculated field which is working and correctly indicating either overdue or notoverdue when I run the query, but when I try and then put "overdue" in the criteria line of the query I get the message Data mismatch in Criteria Expression.
Reviewdate1: IIf(DateAdd("d",(([courseplannedenddate]-[coursestartdate])/5),[coursestartdate])<=Date(),"overdue","notoverdue")
I have rewritten this calculated field several times, but however I write this I can not put anything in the criteria line.
What I am aiming for is the following. The database has a start date and a planned end date and four reviews are scheduled during the length of the course. Therefore I am dividing the course duration up to give a notional review date at equal periods throughout the course. If there is a better way of acheiving this then any advice appreciated
Can anyone please help.
Extra Information
I have now solved the above problem. I had a couple of empty course planned dates and coursestart dates and this was causing the problem. I will post another thread as I now have no idea how to solve this. Many thanks for any of you who looked at this.
Reviewdate1: IIf(DateAdd("d",(([courseplannedenddate]-[coursestartdate])/5),[coursestartdate])<=Date(),"overdue","notoverdue")
I have rewritten this calculated field several times, but however I write this I can not put anything in the criteria line.
What I am aiming for is the following. The database has a start date and a planned end date and four reviews are scheduled during the length of the course. Therefore I am dividing the course duration up to give a notional review date at equal periods throughout the course. If there is a better way of acheiving this then any advice appreciated
Can anyone please help.
Extra Information
I have now solved the above problem. I had a couple of empty course planned dates and coursestart dates and this was causing the problem. I will post another thread as I now have no idea how to solve this. Many thanks for any of you who looked at this.
Last edited:
