View Single Post
  #5 (permalink)  
Old July 6th, 2007, 07:17 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

Quote:
quote:UI elements often need to be reformatted, Access always stores data in MM/DD/YYYY format, so I was told its always a good idea to always ensure you format SQL strings, especially when working with dates.
It's one thing to reformat to display something or to find a criteria for a string, but not for data types of DATE.

A date is a date is a date to the computer... no matter how you format it. So that's why I said that when I saw that the criteria was a date.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division
Reply With Quote