Hello everybody ! Pierre DELGOVE from Rennes, FRANCE.
I am studying a model of database adapted to the management of a veterinary clinic (in order to design perhaps a software that I could use on my own on a GPL license). I meet this practical problem : how could I get a reminder (i.e. after having injected a vaccine for example, I need to recall the client for the next time, for example a year after or six months after) ? The solution I thought about is to store in a field a date which is converted in days (using the TO-DAYS function) then 365 days will be added (if I want a one-year reminder). that will give an other value which will be converted in date by the FROM-DAYS function. Does anybody has an other idea to solve this problem ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
