The_Doc_Man wrote:
and
I know this is an old thread, but I thought I should point out that although The_Doc_Man correctly says that we need to account for the VBA Format function's rounding of date-time to the nearest second, he missed the fact that dates are also affected by this rounding...