Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Internet & the Web (https://www.askmehelpdesk.com/forumdisplay.php?f=177)
-   -   Date not displaying correctly (https://www.askmehelpdesk.com/showthread.php?t=4449)

  • Feb 4, 2004, 02:35 PM
    byrnejeff
    Date not displaying correctly
    OK has anyone ever experience this problem? When a record is saved in an Access database, the date is saved a 2/3/2004 (Feb.03/2004) which is correct. However, when it is displayed, using Format(RSQRY("CheckInDate"), "DD-MMM-YYYY"), it display 02-MAR-2004. Anyone ever experience this?
  • Jul 21, 2004, 11:05 AM
    tadds
    Date not displaying correctly
    I believe your use of the -MMM- is what dictates the month token. Use -MM- instead.

    • All times are GMT -7. The time now is 06:15 PM.