I have an expression within a query that calculates the difference between two dates like this:
Days Late: [filing date]-(DateSerial([related year],[fymonth],[fyday])+[minoffiling time])
This returns the number I'm looking for. However, I'm only interested in positive numbers that would indicate a late filing. Inputting >0 as my criteria results in a data type mismatch error.
I suspect it has something to do with the fields [fymonth] and [fyday] which are expressions from another query that pull the 12 and 31 from "12/31" which itself is stored as a text field <--- problem right here??
Please help. I've wasted enough time. Keep in mind that I'm hardly literate in SQL so I've been working primarily out of the design grid.
Thanks!!