Hi Richard,
I have an issue where I'm trying to email a report out to my vendors. I can successfully filter the data according to date (dd/mm/yyyy). Example show all outstanding orders greater than 12/11/2012 which I then can email successfully. Problem is that I can't email dates less than 12/11/2012 report come out with blank data in the email.

Can you please explain why I'm able to only email out data where date is greater than 12/11/2012 but not less than 12/11/2012. When I filter the data, I can see the data in the report for example I've filtered date to 02/11/2012 but when I email the report there's no data in the report. Has this got to do with US date format. How do I format date to AUS format in VBA

Thanks in advance.

Hamish.

---

Reply from Richard Rost:

Hamish, I'd have to see your database to tell you for sure what the problem is, but if you have your WINDOWS REGIONAL SETTINGS (in your Control Panel) set to a specific country, then that's the setting that Access will use. Make sure you use it in you formats too.