Compare times

Hi guys,

Does anyone know how to compare times?

I need to check if a file was received at or around 2 AM.

As always, thanks for any suggestions or help.

You'll need the format function to make them the same look the same. Here are some examples :

VB Code:

MyStr Format(Time, "Long Time")
MyStr = Format(MyTime, "h:m:s") ' Returns "17:4:23".
MyStr = Format(MyTime, "hh:mm:ss AMPM") ' Returns "05:04:23 PM".

use the DateDiff function