Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

date formatted mm/dd/yyyy, fields shows yyyy/mm/dd

I am using Version: (x64) Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6 In Base I have field in a table with a date that is formatted as mm/dd/yyyy. I have one form that uses a Query to give me an age from the DOB. When I open the query, the date is displayed mm/dd/yyyy. The form with the query has the date displayed correctly as mm/dd/yyyy. For 3 other forms that use the same table as the query, the date field is also formatted as mm/dd/yyyy, yet the field shows the formats the date as yyyy/mm/dd. I have tried to leave formatting for that field as text and if I change it to date format of mm/dd/yyyy. I deleted the date, copied the DOB field that does display correctly. It displayed correctly until the following day. When opening the field, it displays again as yyyy/mm/dd.