Transform a sourcefield with 'date' into acceptable datefield

[Q&A] Using the Platform
1

Hi,

I’m making an xml importdefinition which imports the start date of a price mutation. The source field in the import shows a date in this format: 24-5-2024. The application expects a date in this format: 2024-05-24. How do I transform this sourcefield to an acceptable datefield?

2 Likes
2

Hi Kim,

This can be done by setting a notation in your source field:

afbeelding

In your case your source field has a notation: dd-MM-yyyy. The import engine will convert this source field accordingly to a Novulo date.

7 Likes