I am trying to convert a string to a Date format.
So what i actually want to do is, i want to convert any format of date to DD/MM/YYYY format. For example the format can be d/m/yyyy, m/d/yyyy, mm/dd/yyyy, dd/mmm/yyyy, etc......
I tried using CDATE(value), datetime.convert(value), i even tried
Suppose if the date that i am trying to convert is 5/20/2008, this date is in the format m/dd/yyyy. when i try to convert it as CDATE("5/20/2008"), it shows an error saying "the value is not correct". I think while converting it takes the date as month, so we don't have a month as 20... so i think that's why it shows the error
Can anybody help me to solve this....
The final thing that i want to do is i need to convert any date format to dd/MM/yyyy.
Please help me solve this