has to create login page and change password page

Question

My project requirement:

i have to create registration page, login page and change password page.i have done this task

now i got new requirement.Actually the password has to expire every 30 days.

How to write a query for this.Can any one help me on this

Suthish Nair · Answer

As Irine said compare last password changed date against current date (getdate()). If the number of days is greater than 30 then redirect the user to password change page.

Ayin Rivera · Answer

Add a field where you will record the date when the user change his pw. From that you can check if the pw is already 30 days old.