Date conversion

kollurianu · Post by **kollurianu** » Thu Oct 06, 2005 10:48 am

Hi All,

can i use i Iconv for the following dates

format is mm/dd/yyyy and if the date comes as 5/8/2005.

Thank you all for help,

chulett · Post by **chulett** » Thu Oct 06, 2005 10:54 am

Sure, that should work fine. Now, that's a Server job answer as you marked the post as Server.

kollurianu · Post by **kollurianu** » Thu Oct 06, 2005 1:20 pm

so even if the date comes as 5/8/2005 (mm/dd/yyyy) instead
of 05/08/yyyy still can i use "iconv" function.

Please confirm me.

Thank you,

kcbland · Post by **kcbland** » Thu Oct 06, 2005 1:25 pm

Open DS Manager and write a quick function to test. Your logic would be:

Ans = ICONV(Arg1, "D")

where Arg1 will contain a test date. Hit your Compile button and then the Test button and try 5/8/2005 as the argument. Hit Run and see if the result looks like a number around 13600. I don't know the exact number, but May 15th 1995 was day 10000, so 10 years * 365 days is about 13600.

You will find that ICONV(Arg1, "D/MDY[2,2,4]") is the exact conversion code for your date format. Just a "D" means try to figure it out.

kollurianu · Post by **kollurianu** » Thu Oct 06, 2005 1:37 pm

Thank you so much Kenneth Bland.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 06, 2005 4:41 pm

Just "DMDY" means that the date's in month-day-year order, and Iconv can figure out anything else (delimiters, alpha or numeric month, two or four digit year, and so on).