This is a whopper. I have a text field (StatusDate) in which i store Julian dates. I hae the following formula to convert them to a calender date and compare the result to the current Date().

Date()-DateSerial(2000+Int([StatusDate]/1000),1,[StatusDate]Mod 1000)

This part is fine. I want to use the resulting number form the formula to see if the number is > 10 for example. I am getting a data type mismatch when I try to run the query in Access. Do you have any tips?
Rob