I am using SQL2005 n .Net 3.5
I have a field in my table as Updatedate which contain last update date of the password.
Now I want to force user to change his password after 60 days.Before this,I want to remind him for the password change from 54th day.
6 days left.
55th day 5 days left
60 th day.0 days left and now you have to change the password.
How to do this?