Re: Getting # of days until expiration

[Peter Brawley]

Brian, >I'm trying to show the number of days until the expiration date, which is >30 days in the future from the date in the field. DATEDIFF( DATE_ADD( datefield, INTERVAL 30 DAY), NOW() ) PB ----- Brian Dunning wrote: I have a DATE field that includes a date sometime within the past 30  days. I'm trying to show the number of days until the expiration  date, which is 30 days in the future from the date in the field. I've  tried a bunch of permutations of something like this: select (30 - SUBDATE(CURDATE() - datefield)) as expiration_days All my permutations give me errors. Can someone set me straight? I'm  hoping to get an integer between 1 and 30 (30 day old records are  purged separately). Thanks....

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 1/4/2006


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]