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]
|