| Posted by DA Morgan on 08/27/05 01:20 
thrilled wrote:> with datediff all I can get it to return is months or a total of the
 > days...
 >
 > so if the difference in dates is 12 months 4 days how do I adjust the
 > SQL to accommodate both?
 
 So in February/March you want to return 1 month 2 days some years
 and 1 month 1 day every fourth?
 
 You'll need to write it yourself.
 --
 Daniel A. Morgan
 http://www.psoug.org
 damorgan@x.washington.edu
 (replace x with u to respond)
  Navigation: [Reply to this message] |