This topic is locked
[SOLVED]

 Countdown to pre-determined date

3/5/2014 3:29:52 PM
PHPRunner General questions
L
lynxgeeknyc author

Hello,
I am working on a law database system to easily manages clients. There is something called statute of limitations.

I need to be able to Select date and once you do, it would count down to that date.

A
Anapolis 3/6/2014

I have perhaps a similar question regarding Timing and Countdowns with PHPRunner 7.1 and the Calendar template.
Searching the forums I can't find this as an already answered question.
lynxgeeknyc didn't give enough details about what "it" is here .. > I need to be able to Select date and once you do, it would count down to that date.


I presume for my case I need CRON but I am checking to see if someone has created a PHPRunner "plugin".
My case is needing to send a specific reminder email, say, 15 days before the Appointment date contained in each record in the Appointment table.
As soon as an appointment and its date is submitted I would like for the Reminder Email to be sent at a specified number of days before the appointment date. I can think of a function to automatically calculate the Mail Out Date and store it in its own field as the Appointment date is selected and submitted.
Has someone here set up something similar where a function only "wakes up" once a day at a preset time, collects matching dates from fields, and triggers an email for each record with a server date that matches the "mail today" field? Integrated, I guess, with CRON.
Thank you for your suggestions.

Sergey Kornilov admin 3/6/2014
A
Anapolis 3/7/2014

PERFECT!
This takes care of my problem.
Thank you Jane and Sergey!