DatePicker generated date looks different than usual until saved

From CCMDB Wiki
Revision as of 19:01, 2020 December 10 by Ttenbergen (talk | contribs) (Created page with "{{Bug}} When a field in Access contains a date value, then Access automatically shows a DatePicker tool (calendar) to help populate the date. We use tools like this in all our...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

When a field in Access contains a date value, then Access automatically shows a DatePicker tool (calendar) to help populate the date. We use tools like this in all our date fields. The way the DatePicker works can be a bit confusing, since it displays the date in a different format while entering it than how it will eventually be displayed. For example, if you enter the date "2020-12-13 12:34" into the Px Date in Patient Viewer Tab CCI Pick, then it will display it as "12/13/2020 12:34:00" initialy and only change to the specified format of "20-12-13 12:34" after the line is saved.

Related articles

Related articles: