Please help! Compare weird date string (1 Viewer)

[RainX]

Hi all,

I currently have two strings that look like this 070707 and 020709. What i need to do is compare these two dates and see which one is greater.
Is there any easy way to do this since the year is just yy instead of yyyy?

Thanks in advance

 

[mhartman]

Use CDate(070707)

Regards
Mark

 

[neileg]

You need to be aware of how Access handles two digit years. Try here:
http://office.microsoft.com/en-gb/access/HA010345721033.aspx?pid=CL100570041033