How do I import Xero dates into Microsoft Excel in British format without time value?

Question

Hi there,I have set up a Zap which updates a spreadsheet with details whenever payment is received for specific invoices, including the date on which the invoice is paid. When importing the date from Xero, it comes up in the below format.For tidiness, I would like to import this data into the spreadsheet in a way that a) does not include the time value, and b) converts the date to the British way of reading i.e. 12/07/2023 for 12th July of this year.Is this a rule I need to set within Excel, or I can I set up the Zap to do this before importing the data? Should I just do it manually everytime we receive a payment?Looking forward to a response. Thanks!Josh

Liz_Roberts · Accepted Answer

Hi @joshb3399👋🏽 Welcome to Community!It sounds like a Formatter step would do the trick here. Here’s a handy video that explains how to use it😊

joshb3399 · Answer

Perfect, thank you Liz!Josh

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded