mapping problem for date field

[Former Member]

Hi XI Friends..

In my file to idoc scenario..

i have field date value :2006-10-10T14:10:10

i have convert the above field into two fields idate :20061010

itime:141010

i used substring datetransfer functions..

but in static test of message mapping ..i am getting value for itime as 021010

if we give before 12:00:00 its converting properly..after 12.:00:00 its taking 12hr format only..

please guide me..

regards

ram

[Former Member · Accepted solution]

Hi Ram,

Is this still a problem?

I think the hint will also work in this case:

sourcefield --> replaceString(sourceField/constant[T]/constant[]) --> TransformDate(yyyy-mm-ddHH:MM:SS --> HH:MM:SS) --> targetFieldTime

sourcefield --> replaceString(sourceField/constant[T]/constant[]) --> TransformDate(yyyy-mm-ddHH:MM:SS --> YYYYMMDD) --> targetFieldDATE

Daniel

[Former Member]

Yes right use the DateTrans function.

for idate from yyyy-MM-dd HH:mm:ss to yyyyMMdd

and

for itime from yyyy-MM-dd HH:mm:ss to HHmmss

regards,

robin

[Former Member]

Hi,

Did you try datetrans function from date functions ?

Regards,

Sudheer.

[Former Member]

Hi Ram,

Use date transformation function From date function category

Format of source date yyyy-mm-dd HH:mm:ss

Target Format yyyymmdd HHmmss

Thanks,

TUhin