Results 1 to 2 of 2

Thread: Dates

  1. #1
    Join Date
    Dec 1969

    Default Dates

    I am populating a date field with 3 separate drop down menus: day, month and year fields. All are varchars. What I would like to do now is check this date against the current day - how do I concatenate my three date fields into one date field so that I am able to compare or manipulate it? <BR>p.s. - I am using SQL7

  2. #2
    Join Date
    Dec 1969
    Los Angeles, CA

    Default RE: Dates

    dateVar = MonthDD & "/" & DateDD & "/" & YearDD<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