date problem

Results 1 to 3 of 3

Thread: date problem

  1. #1
    Vivienne Guest

    Default date problem

    Hello everyone,<BR>I have this huge problem which is killing me.<BR>in my site, i have a text box for date which is displayed in the following format mm/dd/yyyy. However when i insert the date in my database it is inserted in the following format mm/dd/yyyy. So when i do a query for a particular date, i do not get any results because of the date format. For e.g query a transaction on the 10/09/2000 gives me nothing coz in the database, the record was inserted as 09/10/2000.<BR><BR>i have used the session.LCID and still no results.<BR><BR>Please Help<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: date problem

    Have you tried using DateSerial?

  3. #3
    Suresh Guest

    Default RE: date problem

    Why don&#039t you try with date format stored in the DB?<BR>chg. criteria to mm/dd/yyyy format? <BR><BR>does that make sense??<BR><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