Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 how many days until birthday

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-01-02 : 08:30:09
Skip writes "say we have a date field containg a birth date how do i notify the user on login its 10 days before your birthday ?"

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2004-01-02 : 10:44:19
please try to help yourself first....by doing "a search" here for "birthdate/birthday"....similiar problem have come up here before...


The solution involves DATEDIFF.
Go to Top of Page
   

- Advertisement -