Hi,

I was having some problems converting values of Dates.

I have a field that contains dates in the format of LEFT(DATETIME, 11) of SQL which basically gives you the date in the format "Jun 19 2006", However I need to convert it to '06/19/2006', and I don't recall any format for the DateCVT function that can do this. Does anyone know of a solution to this?

Hi

using the DEFINE you can convert the DateFields.

Thanks,
Kalyan

Check this code,

DEFINE FILE CAR
DATE1/A20='JUN 26 2006';
DATE2/HYYMDS=HINPUT(14, DATE1, 20, 'HYYMDS');
DATE3/MDYY=HDATE(DATE2,'MDYY');
END

TABLE FILE CAR
PRINT DATE1 DATE2 DATE3
BY CAR
END
-EXIT

Thanks.

This questions is related to thie thread. How do you convert the datetime "2006/05/24 00:00:00" to "5/24/2006".

Another would be to convert "2006/10/09 00:00:00" to "10/9/2006".

I used DATE/HMDYY in my table file but it returned 05/24/2006 & 10/09/2006.

Thanks in advance.

quote:

Another would be to convert

Take a look at the following link on IBIs support site:

http://techsupport.informationbuilders.com/tech/cof/cof_tcn_062.html