Date Conversion

Results 1 to 3 of 3

Thread: Date Conversion

  1. #1
    Join Date
    Dec 1969

    Default Date Conversion

    Halo,<BR><BR>I have problem converting, for example 3/3/99 into a form that can be written into the database. I have tried CDATE but it seems to be of no use.<BR><BR>Please enlighten and thank you

  2. #2

    Default RE: Date Conversion

    Hi I have not tried the date formate u want to save in data base , but sucessfully retrived the data between two dates by using following Queiry<BR><BR><BR><BR>SQL= "Select * from Request where between #" & per & "# AND #" & dat &"# " <BR><BR><BR>Where request is table name, per is variable containing begnning date and dat , ending date .<BR>Try this<BR>

  3. #3
    Sonali B. Guest

    Default RE: Date Conversion

    1. try convering date using vbscript function<BR> FormatDateTime(date,vbGeneralDate)<BR><BR>2. or write proper SQL to save into the database..<BR>e.g. <BR> "insert into tablename values(To_Date(&#039" & Format(dtStartDate, "DD-MMM-YYYY") & "&#039, &#039DD-MON-YYYY&#039))"<BR><BR>Good Luck<BR><BR>Sonali B.

Posting Permissions

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