date question

Results 1 to 3 of 3

Thread: date question

  1. #1
    Join Date
    Dec 1969

    Default date question

    how to query a date from database?<BR>eg: Select * from Table where date &#060; 13/02/2001. <BR>what should the date be stored as? string or integer?

  2. #2
    Tim Snyder Guest

    Default Date?

    Date should be stored as DATE ?<BR>Am I missinf something or is it you?

  3. #3
    Join Date
    Dec 1969

    Default RE: date question

    Select * from Table where date &#060; 13/02/2001<BR><BR>Firstly, this would try and select values from a text field called date. This will mean that you won&#039;t get proper checking on the less than part, so you need date to be stored as a date/time field. Secondly, if you&#039;re using MS Access then be warned that date is inadvisable for a field name, because it is a Microsoft reserved keyword. If you need to access it you will need to say [date]. So, if you are using Access, make the query this:<BR><BR>SELECT * FROM Table WHERE [date] &#060; #13/02/2001#<BR><BR>HTH<BR>Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts