I tried direct mapping but the field in the destination profile did not get populated.
Note: I cannot change the type of a field in the source or the destination profile.
Can you please elaborate and provide profile also.
Make sure you specified Date Format in your source XML profile.
If it no there, enter it manually.
Retrieving data ...