>Hi,
>
>I have two fields, Date type and Char field that stores a time in the following format "HH:MM:SS". I need to create a DateTime expression (so that I can store it in a new field). I can use the VFP function DATETIME() to do it and pass parses values of the Year, Month, Date, Hours, etc. Is there a simple way? TIA.
dDateField = DATE()
cTimeField = TIME()
? CTOT(TRANSFORM(DTOS(dDateField), "@R 9999-99-99") + "T" + cTimeField)
Luis María Guayán
Tucumán, Argentina
________________________________
SysOp de
www.PortalFox.comNada corre como un zorro
________________________________
