I´m creating a little program which runs a database...
In this database there´s a field "Birthday"
And i want my program to tell me the name of subject the day before his birthday.
Any ideas..
Printable View
I´m creating a little program which runs a database...
In this database there´s a field "Birthday"
And i want my program to tell me the name of subject the day before his birthday.
Any ideas..
I'm assuming that the field "Birthday" contains a date of birth. What I would do is:
[list=1][*]Run Your program when Windows starts[*]Take the info (the date) from the database (store it in the variable - you could use an array if needed)[*]Compare the date-variable with today's date (using DateDiff function)[*]If the difference between the two dates is one day then display a message saying that "QWERTY has birthday tomorrow!!!!!!!!!!!!"[*]If the difference is greater than one day, ignore everything and do whatever you have to do[/list=1]
HTH