The data source of my master files is some Web Services data, and I'm having trouble with one of the date fields.

The field format is HYYMDm.

The data in the field appears to be showing as: 2010-08-04T00:00:00.

No matter what I try, on my final results I get a "." for the original data, and a blank value for the translated format attempts.

I've tried these defines with no luck:

STOPDT/YYMD= HDATE(SART_GETFACILITIES.STOPDATE,'YYMD');
STOPDT2/A20= HCNVRT(SART_GETFACILITIES.STOPDATE,'(HYYMDm)', 26, 'A20');
STOPDT2/A13= HCNVRT(SART_GETFACILITIES.STOPDATE,'(HYYMDm)', 19, 'A13');

Can anyone help with the correct way to pull this data?

Thank you.

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

You must add the following line to your FEX:

SET DTSTANDARD=STANDARD

You don't need any DEFINEs.

Let me know how it goes.

That worked!

You rock!

Why coudn't you have had this question a week ago, We just went through a Case with IBI to solve this.

The Date String is an XML standard date string, and WF won't read it if DTSTANDARD isn't set to STANDARD.