Results 1 to 2 of 2

Thread: Strings and Dates

  1. Feb 7th, 2001, 07:16 AM #1
    kanejone
    kanejone is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2000
    Location
    Ireland
    Posts
    224

    Question

    I have an ASP page that searches for three different values in a Database. The first is that ValueDate the second is BeforeValueDate and the third is AfterValueDate. I have the ValueDate as a String in my SQL database.
    I am trying to find out how to find the values for dates before a given ValueDate and after a given ValueDate.

    Any Help is really appreciated with this. I am using JScript .

    Thanks
    JK
    Reply With Quote Reply With Quote
  2. Feb 7th, 2001, 08:44 AM #2
    bsmith
    bsmith is offline
    Lively Member
    Join Date
    Jan 2000
    Location
    Springfield, IL
    Posts
    124
    Use the CONVERT() function in SQL Server to convert the string to a date and do your compares that way.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width