Comparing two dates

[joefoulkes]

Can anyone think of a way to compare two dates that may be in a different format ? For example, I wan't to check that someone has the correct version of a file on their pc: I know that the date on the file should be 20/10/2000, when I use vb to return the date from the local file it returns it in the short date format on the pc, which may be different i.e. 10/20/2000. Although those dates are the same, they are represented differently, so how can I compare the two, or make them both the same format ?????

Use the Format function to convert dates into a specified format.

[makai]

your system is set up either to recognize the US month first notation or the UK notation where everything is backwards

You can directly compare Dates declared like:
dim d as Date

however if you want to read in a date that is backward on your system with the CDate function then you must know that it is backward and parse (and rearrange it) yourself