Date format in Graphical Mapping

[Former Member]

Hi Experts,

How to do the date format?

Actually, I have to get the output with this format (YYYY-MM-DD)

Regards

Sara

[SudhirT · Accepted solution]

Hi,

Use the DateTrans function and set the target as YYYY-MM-DD and source as incoming date format in its property.

Thanks!

[Former Member]

Hi Sara,

chk date tranform function ,

in that we have option for format of source data and target data.

U can enter the complete details like date separator , time separator and data & time separator... if the source date format has any further characters added in source data u need to mention those charaters also during formatting withing single quotes.

Regards,

Syed

[former_member200962]

Hi,

In Message mapping under the standard functions you have functions for Date format...here you can find the DateTransform function...

SourceDate---->TransformDate--->TargetDate

Here in the properties give what format you want.

Regards,

Abhishek

[Former Member]

use date function and select datetrans and give ur soruce date format and output date format.

chirag

[Former Member]

hi

use Date Transfer Function in Graphical Mapping.

if u double click on that it will show source and target formats, u will give dates in that based on u r requirement.