The CDate function will always return a value based on the active database calendar, whereas date constants are always evaluated by using the Gregorian calendar.