Hi,
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!