string date covertion to number.....

[jstar7]

Hi there,

I have a string: Jan 01 2002

I need to compare it with another string: Nov 11 2002

I need to return the greater date....I assume the best way is to change them to numbers and compare the numbers like in SQL. How can I do this?

cheers for the help,

Jstar7

-------------------------------------
...what rhymes with month?

 

[mumbojumbo]

Look at the FormatDateTime func

ooooooooooooooooooooooooh bugger.