[EMAIL PROTECTED] wrote:
"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....
Weighing in for a second...
Given the context of "month", I suppose it is no more goofy than saying
"see you next year" to someone one second before midnight on New Years
Eve. I'd guess that's why most debt instruments define what they mean
by "month" as a specific, if arbitrary, day in the month.
John
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------