Results 1 to 3 of 3

Thread: dateadd

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Question Unanswered: dateadd

    Hi guys I am trying to convert this to date add because MS SqL and Jet SQL dont exactly speak the same language

    Code:
    =DateSerial(Year([FINALSUIT])4,Month([FINALSUIT]),Day([FINALSUIT]))
    I am trying to calcuate the finalsuit date for every 2 years becasue that when employees have to get their gaming license renewed, so I'm trying to add the renewal year by 2 because they have to get it done every two years

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd suggest:
    Code:
    DateAdd(year, 2, FINALSUIT)
    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Good Gravy!!!!!!!!

    Ahhh man thanks so much Pat I made that harder then what is was no wonder mine wasnt working

Posting Permissions

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