My zap is using Mail Parser to fill a Excel sheet.
I’m trying to figure out a problem on date format.
The mail contains a date which is DD/MM/YYYY, this format is good for me.
When the row is filled on Excel, it turns to MM/DD/YYYY.
I even tried to use Formatter but the problem is still the same.
Can you help me ?
Thanks a lot,
Best answer by steph.n
I had a look at the Zap, and the issue here is that, although the transformation is happening correctly in the Formatter step (Step 2), the results of that transformation are not being used in the Excel step. Right now, it's using the date coming from Mail Parser. To fix this, you can map the output of Step 2 in the Date cell in Excel:
This should give you the correct date!
Would you give this a try and let me know how it goes? I'll be on the lookout for your answer!