Hello,
I have run into a rather interesting challenge I can’t seem to solve.
I create a Migration Job for the Excel addin, its purpose is mass change shop order dates.
The Source Mapping was auto generated via the default settings on the migration job.
When I Open the Migration Job in Excel and use the search and try to search with a date field, the search does not convert the query into the appropriate date logic. Is this something I need to somehow program into the Source Mapping itself?
Migration Job:
Excel IFS Search:
Checking the Advanced Tab to validate and resulting error:
Manually correcting this makes it work. This however is not great for the end user as they need to know to make this change when searching for dates and becomes more difficult to use.
Looking forward to some possible solutions.
Best answer by Curious_User
View original