PDA

View Full Version : Date not displaying correctly


byrnejeff
Feb 4, 2004, 02:35 PM
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?

tadds
Jul 21, 2004, 11:05 AM
I believe your use of the -MMM- is what dictates the month token. Use -MM- instead.