2 replies to this topic

[weizixu]

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! 

[Ana Henry]

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

Attached Thumbnails

• 

Attached Files

•  Convert Dates.zip   274.09KB   171 downloads

Edited by Ana Henry, 23 August 2023 - 09:24 PM.

[weizixu]

Hi Ana, 

 

It works! Thanks so much for the help!