I don't understand what is going on here, any help would be much appreciated
I have a calculated field called ofs that determines how many days to subtract from a date based on the day of the week
ofs: IIf(Weekday([dell date])=2 Or Weekday([dell date])=3 Or Weekday([dell date])=4,5,3)
Then I am using this in the calculated field below
dd: IIf(Left([tbs.co],1)="t",[del date]-[ofs],[due date])
Works fine until I filter with date()
Then Access asks for parameter for OFS?