I have the following fex:

DEFINE FILE CAR
test_FIELD/HYYMDs=DT(20080105140000354);
END
TABLE FILE CAR
PRINT
CAR
test_FIELD/HMDYYS
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
END

When I PCHOLD the FEX to HTML, the date comes out as: 01/05/2008 14:00:00
When I PCHOLD the FEX to XML, the date comes out as: 20080105140000354

I would like to use this FEX to populate controls in the HTML Layout Painter but I need the date to come out 'pretty'.

Any ideas?

This message has been edited. Last edited by: Kerry,

The reason the dates come out pretty in HTML is because you are seeing the 'display' format. That is what the HYYMDs is.

If you want the slashes and colons in the XML, you will have to convert the datetime to alpha and then use the EDIT funtion to put the special characters in.

Thanks. That worked. I actually used HCNVRT.