lmf232s
02-13-2006, 02:33 PM
Im looking for a MOD like Function.
You may be able to help me come up w/ a different solution
What i need to do is send a email reminder every 24 hours its overdue. This could continue for weeks but most likely it will be taken care of w/ the first reminder.
What i have so far and it works but i need it to be more flexable.
Select dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) as TotalTime
From Requests
WHERE dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 24
w/ out typing
WHERE dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 24
AND dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 48
AND dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 96, etc...
You may be able to help me come up w/ a different solution
What i need to do is send a email reminder every 24 hours its overdue. This could continue for weeks but most likely it will be taken care of w/ the first reminder.
What i have so far and it works but i need it to be more flexable.
Select dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) as TotalTime
From Requests
WHERE dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 24
w/ out typing
WHERE dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 24
AND dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 48
AND dateDiff("Hour", Date_Created, CURRENT_TIMESTAMP) = 96, etc...