
Recently while we were upsizing an MS Access application to SQL Server, we noticed some strange behaviour regarding the way dates were displayed. Some data entry screens in our MS Access client required users to enter time values in the format: 8:15 am, with no corresponding date value. Although the application displayed and treated these values as pure time values with no date portion, Access was storing a default date (or zero date) along with the time value
|