Correct Syntax for Listbox Dates

[coreytroy]

Please Login or Register  to view this content.

In the highlighted code, i cannot seem to obtain the correct syntax for the dates found in either

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

.

I tried using .Text instead of .Value to no avail.

I think the reason i am not getting the desired result is that the dates are stored as dddd dd mmmm yyyy, yet the listbox is populated in a dd/mm/yy format.

How can i receive a match when there is 2 separate date formats to achive the result above
?

[coreytroy]

Please Login or Register  to view this content.

solved the problem for me.