Sometimes when building a Zap, you may encounter a date coming through in a strange format.

Example: you want to pull a lead from LeadSimple into a Google spreadsheet. However, the created at date comes through in a strange format.

If you would like to reformat the dates, use a Formatter step in Zapier. (In this case, this would be before the final action in the Zap to create the spreadsheet row in the spreadsheet, so we can use the reformatted date in that action.)

The action event you'll want to use is Date/Time.

Next, you'll want to choose format as the action we will complete.

For the Input, you'll want to select the date field from your earlier trigger (the one in the wrong format).

Then, select the format you want the date to be reformatted into. You'll notice there are a lot of options.

Also be sure to add the From format, and the To and From timezones.

Also be sure to run the test to get the output to use in your next step.

You'll notice that the output now is what we want in the Google sheet!

In your action, update it to pull the date from the output of the Formatter step rather than the original date field.

Run another test!

Now the date format looks great in our spreadsheet!