FIlter by date

Results 1 to 2 of 2

Thread: FIlter by date

  1. #1
    Join Date
    Dec 1969

    Default FIlter by date

    Hello,<BR><BR>I am trying to filter a recordset by date, in the format dd/mm/yyyy, from a SQL database. The SQL field, DateStamp, is stored as DateTime eg. 13/12/2004 12:44:28.<BR><BR>My criteria looks like this which does not work: DateStamp &#062;= #01/01/1990# AND DateStamp &#060;= #01/01/2005#<BR><BR>Does anyone have any suggestions? Thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: FIlter by date

    For SQL Server, you should be using something like this:<BR>[code language="T-SQL"]DateStamp BETWEEN &#039;01/01/1990&#039; AND &#039;01/01/2005&#039;[/code]<BR>

Posting Permissions

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