DatePicker generated date looks different than usual until saved: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(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...")
 
mNo edit summary
 
Line 3: Line 3:
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.  
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.  


'''The format used by DatePicker is based on the Date/Time format active on the laptop when CCMDB starts. You can change it to the format we use in CCMDB, but it will then be that format for other programs you run as well. To change it:
# right-click the clock in the bottom right hand corner
# click "adjust date/time"
# click "Region" in left panel
# click "change data formats" (small and gray in bottom of right panel)
# under "short date" pick the yy-mm-dd / year month day / 20/12/13 format we generally use in Access.
If you find you don't like what that does to your dates in other programs, set it back to the regular mm/dd/yy format.
(or run the following in the command prompt:
<code>reg add "HKCU\Control Panel\International" /V sShortDate /T REG_SZ /D yy/MM/dd /F</code>
)
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}


[[Category:IT Instructions]]
[[Category:IT Instructions]]

Latest revision as of 19:30, 2020 December 10

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.

The format used by DatePicker is based on the Date/Time format active on the laptop when CCMDB starts. You can change it to the format we use in CCMDB, but it will then be that format for other programs you run as well. To change it:

  1. right-click the clock in the bottom right hand corner
  2. click "adjust date/time"
  3. click "Region" in left panel
  4. click "change data formats" (small and gray in bottom of right panel)
  5. under "short date" pick the yy-mm-dd / year month day / 20/12/13 format we generally use in Access.

If you find you don't like what that does to your dates in other programs, set it back to the regular mm/dd/yy format.

(or run the following in the command prompt: reg add "HKCU\Control Panel\International" /V sShortDate /T REG_SZ /D yy/MM/dd /F )

Related articles

Related articles: