"Virgilio Fornazin" <[EMAIL PROTECTED]> wrote: > DATEDIFF should compute the difference by arithmetic subtracting M/Y in > month case, if I'm not wrong > > ex: > > DateDiff (month, 1-1-2007, 3-30-2007) will return 2 > > Its that right ?
So datediff('month', '2008-02-01 23:59:59','2008-01-31 00:00:00') should return 1 even though the difference is really only 1 second? Seems goofy to me.... -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------