<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>thanks Fajar, Let me give a try.<br></div><div><br></div> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <div style="font-size: 12pt; font-family: 'times new roman', 'new york', times, serif; "> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Fajar A. Nugraha <list@fajar.net><br> <b><span style="font-weight: bold;">To:</span></b> john decot <johndecot@yahoo.com>; FreeRadius users mailing list <freeradius-users@lists.freeradius.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, December 6, 2011 6:38 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Expiration email<br> </font> <br>
On Tue, Dec 6, 2011 at 7:22 PM, john decot <<a ymailto="mailto:johndecot@yahoo.com" href="mailto:johndecot@yahoo.com">johndecot@yahoo.com</a>> wrote:<br>> Thanks for the reply. I am also trying same but couldn't compare with the<br>> field on the database as Expiration attribute use character value. I wish<br>> someone give me any idea on comparing those parameter inside database.<br><br>Several ways I can think of (completely untested):<br>(1) Use http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date<br>(or whatever equivalent function in your db) to convert the column to<br>date before comparison<br><br>(2) Pick a time to alert the user (e.g. ONE WEEK before expiration),<br>then use whatever programming language of your choice (e.g. php) to<br>convert the date into the format used in expiration attribute (e.g.<br>using date_format). Then you only need to compare for exact
string<br>match.<br><br>-- <br>Fajar<br><br><br> </div> </div> </div></body></html>