Mukesh

Mukesh

  • NA
  • 228
  • 43.1k

Automatci value change after 90 days

Jun 8 2016 3:12 AM
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)