View Single Post
  #4 (permalink)  
Old July 6th, 2007, 07:09 AM
robzyc robzyc is offline
Friend of Wrox
Join Date: Mar 2007
Location: Hampshire, United Kingdom.
Posts: 432
Thanks: 0
Thanked 1 Time in 1 Post

quote:Originally posted by SerranoG
 Not quite, Rob. Formatting is used only for the purposes of displaying something on a form or report. It is not used as a criteria for a query or as a WHERE condition.
 Why is this? 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.

quote:Originally posted by SerranoG
Also, the date range is supposed to be a date, not just a month.
Good Spot! I missed the fact that it was only a month!!

Reply With Quote