TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
vishnuvardhan diyyala
NA
38
115.1k
SQL query for date comparision
Apr 13 2011 2:54 AM
Hi everybody...,Gudmorning to all
This is vishnuvardhan.i have a small dout.That is in my project i have one table that contains username psaaword and last chage date of password.here password is only change by administrator only.y because any error in password formate clint pointout us.Here userid password is use to login clint server.So we give rights to admin only to change all passwords.so here my problem is in admin window one link is ther.that is passwords need to change today.password need to change once in 30days irrespective on working days.total 30 days.I m unable to write SQL query for this.In thta window i have one datagridview.while picking that link the passwords appear which changed before 30 days from today date.Thais is my prob................? Any one Please help me to solve my problem..
Thanks in advance.
Reply
Answers (
4
)
send mail with attachment file that put on other Ip address or server
Events