Tuesday, February 14, 2012

dateadd

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

=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 yearsI'd suggest:DateAdd(year, 2, FINALSUIT)-PatP|||Ahhh man thanks so much Pat I made that harder then what is was no wonder mine wasnt working

No comments:

Post a Comment