RadhaKrishnaKiJaya
asked on
Need help with a query
Hi Experts,
I want to update student status if the date is joindate is more than 180 days old from todays date.
Thanks in advance!
I want to update student status if the date is joindate is more than 180 days old from todays date.
Update Students Set IsNew = 0
Where joindate - todaysdate > 180days
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you so much!
You are most welcome.
I find dateadd to be more readable: dateadd(day, -180, getdate())