Different Date formats in text to be recognised as date value
Hi all,
I have a problem with some date formats where people send to me in various
forms (text format)
1) "DD\MM\YYYY"
2) "D\MM\YYYY"
3) "D\M\YYYY"
4) "MM\DD\YYYY"
5) "MM\D\YYYY"
6) "M\D\YYYY"
Is there anyway to be able to convert these to date values and be reflected
as "DD\MM\YYY" using vba.
Thank you for any help rendered in advance.
Rgds
Ray
|