DateDiff

[garygdj]

Is there a way in a query to write a datediff that looks at all the possibilities month, day, year? I have 10 different fields that I need to do a date diff on. I would like to have the fields checked in one place rather than 10 day checks then 10 month checks and 10 year checks. I don't need to use the data any where but I need it to let me know if there is a difference between a calculated date and a date that was input by a user. If there is then I know the user input the wrong date, and it shows as an error.

Thanks

 

[garygdj]

It's not working that way for some reason. For example lets say the two dates are 02/01/2016 and 02/16/2021. A date diff should catch that. however, it's not. the fields are both formatted the same. Heres the strange part. If I go back to my table and change the day in the first date from a 01 to a 16 then go back and run the query it will catch it. Or if I change the year in the second date to 2016 it will catch it. I've got to be missing something.

Sorry about the initial question. I left for home and thought about how the question was not really done very well.

 

[garygdj]

I got it figured out and it was all my fault. I hate those kind of issues.