1
Answer

Automatci value change after 90 days

Mukesh

Mukesh

8y
583
1
Hear is my code  want to know how will  IsActive ='Y' Automatic After 90 Days
 
 
SELECT * FROM FacultyRelievingDetails
WHERE ApplyDate >= DATEADD(DAY, -90, ApplyDate) And FacultyId='LCVD-2003396' AND CollegeId=387 AND IsRelieved='Y'
 
 
please Help Me 
Answers (1)
Next Recommended Forum