Skip to Content
Oct 07, 2013 at 03:18 PM

DateTrans Mapping Error



I'm using DateTrans function to convert the date from MDM to a format that is acceptable by our receiver system. The format in MDM is mm/dd/yyyy hh:mm:ss GMT and the expected output is mm/dd/yyyy hh:mm

So basically, the mapping just needs to remove the seconds and GMT part of the date.

However, for some reason, the mapping is failing and producing a different value than the source.

Here's the actual mapping:

Did I miss something? Appreciate your inputs regarding this. Thanks a lot!


Capture.JPG (21.3 kB)