Hi,
How can I change time format “10/Dec/2014” to"10/12/2014"?
I tried to use data wizard “datevalue” function, but to read it back to “dd/mm/yy” format. Thanks!
Hello,
You can accomplish this with a few steps within a DataWizard (attached image). I have also attached a zip file with a phoenix project (v8.4) and object settings in case you are using a Phoenix version <8.4. This datawizard will work as long as the month is spelled out. If you have a mixture of dates for example 01/Feb/2003 and 01/02/2003, it will not work for the later because it assumes that the numerical month is the first entry.
Hope this helps,
Ana Henry
Convert Dates.zip (274 KB)
Hi Ana,
It works! Thanks so much for the help!