Sunday, January 15, 2012

Sending date to any external system in external system format(Siebel date format is mm/dd/yyyy and the external system date format is dd/mm/yyyy)

Use EAI Data Transformation Engine in the workflow, go to application-> Site map -> Administration Integration -> Data map editor

















This Expression “Mid([Date of Birth],4,2) + '/' + Left([Date of Birth],2) + '/' + Mid([Date of Birth],7,4)” will converts the date format from mm/dd/yyyy to dd/mm/yyyy(01/22/1989 to 22/01/1989)

In similar way we can change the formats
Examples
01/22/1989 to 01-22-1989
01/22/1989 to 1989/22/01

1 comment: