Date Comparison

[lucidity23]

The following is the date format I use:

11/14/2001 1:53:15 AM

I want to compare 2 dates in that format. I know I can split up the whole string and compare them that way. I need to compare the dte and time.

any quicker ways?

http://www.clan-rt.com

- carpe diem -

 

[cdidion]

There is a DateDiff function that you can use to compare the different parts of two dates. You provide it with two dates and the interval (days, minutes, etc.) difference you're looking for.

That should help quite a bit. -Chris Didion
Matrix Automation, MCP