This function has always worked in the past, i must made a change some where and now it wont work (prevents my append and update queries). I just removed the functions and set-up the query using TOP values. But any ideas why this fuctions just quick working, what if I use Int([Date])?
DT: Format([Date],"mm/dd")
Between DateAdd("d",-21,Date()) And Date()
It's build into a lot of my charts and queries and would be a huge pain to re-move all. I attached a picture of the error. I'm receiving. Never had this before, and I've had my dates formatted that way to save space for a long time. oopps what did i do?