Date and time
Posted: Tue Sep 25, 2007 4:04 am
Hello,
I have to send emails exactly 24 hours before an event occurs. The system then waits for 5 minutes then again checks is there any new event within next 24 hours.
I am stroing the event date informat.
1. How to check the event if it is inbetween? i.e if the event is for 10:12 PM and the system check every 5 minutes
the event will never be equal as it will check once at 10:10 and again at 10:15
2. Should i have to convertto ? to comparing?
If there is any better way of doing it, please let me know.
Thanks
I have to send emails exactly 24 hours before an event occurs. The system then waits for 5 minutes then again checks is there any new event within next 24 hours.
I am stroing the event date in
Code: Select all
date('Y:m:d H:i:s');1. How to check the event if it is inbetween? i.e if the event is for 10:12 PM and the system check every 5 minutes
the event will never be equal as it will check once at 10:10 and again at 10:15
2. Should i have to convert
Code: Select all
date('Y:m:d H:i:s')Code: Select all
time()If there is any better way of doing it, please let me know.
Thanks