Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Problems in accessing the Date Field

 
Amit Roy
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi frns
I am facing a problem in accessing a date field fron MS Acess Database using SQL Query wher in i have to use a "Date" in the "WHERE clause"
Amit Roy
 
Brian Nice
Ranch Hand
Posts: 195
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If I remember correctly, dates in Access need to be surrounded by # signs instead of ' signs.
Brian
 
stephen raj
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what problems are u facing with date?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic