Forum Discussion
efeurich
Helper I
Helper IConverting non-conventional date in conventional date format
Hi there Community, I have trouble to convert a date format from a project management system to a "normal" date format. The format that is in the Excel spreadsheet is 2019 - Januari but needs to be...
Hi v-chenwuz-msftm
Thanks for your reply.
The odd thing here is that I tried to replace the values in Transform data, but that didn't work. I ended up changing the data manually in the source xlsx file to resolve this problem.
I have a working data-set now but am still researching this issue.
efeurichHelper I
Helper IHere a screenshot