Hi
I hope someone can help me!
I have a query which works out the date in 9 weeks time so:
Reminder date: [Last review date]+63 which works.
Then from this result I want to search between 2 dates so I typed into the criteria box:
Between [Enter Todays Date( dd/mm/yyyy)] And [Enter End Date(dd/mm/yyyy)]
But the dates for next month also appear in this result?
Could the formula be causing this?

Thanks

I believe you are struggling against the internalional date (http://allenbrowne.com/ser-36.html) problem. BTW, do you know about the DateAdd() function?

I have checked the regional dates and they are all set to uk. I have looked briefly at the adte add function but can you only set a specific date? As I want to be able to change Today's date every day. Hope that makes sense!

Access wants US dates rather than UK dates. Use Allen's scheme to force the conversion. As for changing today's date every day, I don't see the problem.

I have changed the formula to the date add function which works but my query is still coming up with random dates. How do I add the conversion? Sorry have never used SQL codes before

Try something like:
Between Format([Enter Todays Date( dd/mm/yyyy)],"\#mm\/dd\/yyyy\#") And Format([Enter End Date(dd/mm/yyyy)],"\#mm\/dd\/yyyy\#")

I still can't seem to get it to work! I think I'm going to set it up in Excel with the formulas then import it into the database. Seems like the quickest and simplest solution! Thank you for your help RG!

Does it work if you enter the date as MM/DD/YYYY?