G
Guest
I've got a query that used to work. When I started working on it this
morning, it said that the program had been closed incorrectly and it needed
to try to repair itself.
Now I get the error message: "Data type mismatch in criteria expression".
I've tracked the "mismatch" back to some of my date/time expressions. This
used to work:
IIf(Weekday([start_date])<=5,DateAdd("d",(5-Weekday([start_date])),[start_date]),DateAdd("d",(12-Weekday([start_date])),[start_date]))
But now it doesn't. Any suggestions??
morning, it said that the program had been closed incorrectly and it needed
to try to repair itself.
Now I get the error message: "Data type mismatch in criteria expression".
I've tracked the "mismatch" back to some of my date/time expressions. This
used to work:
IIf(Weekday([start_date])<=5,DateAdd("d",(5-Weekday([start_date])),[start_date]),DateAdd("d",(12-Weekday([start_date])),[start_date]))
But now it doesn't. Any suggestions??