Forum Discussion
formatting date where you don't live in USA
You can also enter custom date formats using the patterns I had provided into the Format property for Text Boxes like seen in attached screenshot and documented here:
https://www.techonthenet.com/access/forms/format_date2007.php
For international date patterns such as:
m/dd/yyyy
When you edit the Format property for a field in Table Design such as to specify default date format (or for numbers etc as well), then that will be used as well for any form or report control that you bind (link) to that table field, as well as for queries which select / return / include that field.
Does what I had described in my previous replies – regarding what Access currently supports for automatic international date format (eg. DD/MM/YYYY) display (based on each user's locale settings), as well as ways to force international date format display (via Format property for Fields in Table Design, Text Boxes) and existing SQL/VBA functions (instead of the complex date parsing / calculation you had mentioned doing) – cover what you are wanting to do in Access?
If not, if you can describe specifically what you are trying to accomplish with dates, beyond those supported use cases, I may be able to help with that. And, if not, you can submit a feature request to add built-in support for that.
Features requests for Microsoft Access can be submitted on User Voice at the link below, if you want them to be considered by the Microsoft Access development team:
https://access.uservoice.com/
I hope that helps.
Best regards,
Dan
--
Dan Moorehead
Founder, PowerAccess (https://www.PowerAccess.net
"Empowering Microsoft Access with new Tools | VBA Framework | PowerGit | PowerSQL | CodeGen | Excel➜Access➜SQL Conversion"