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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment