Skip to main content
Best answer

Format of date received from Hubspot

  • April 19, 2021
  • 2 replies
  • 774 views

Hello everyone,

I am managing a report with data that I get from Hubspot and save into Google Spreadsheet via Zapier.

The problem is in the date format, once I am receiving the date, it looks like this:

First I thought that is problem of Google Spreadsheet, but then I’ve noticed that date has the same format in Zapier too:

Anyone everencountered an issue like this or might be aware of that can be fixed?

 

Thank you in advance.

Best answer by Nate

Hi @IgorP,

You should be able to accomplish that with Formatter by Zapier. Use it before the Google Sheets action and select the Date/Time action event → Transform → Format.

Let us know if this solved the issue :) 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

2 replies

Nate
Forum|alt.badge.img+6
  • Zapier Solution Partner
  • Answer
  • April 19, 2021

Hi @IgorP,

You should be able to accomplish that with Formatter by Zapier. Use it before the Google Sheets action and select the Date/Time action event → Transform → Format.

Let us know if this solved the issue :) 


  • Author
  • New
  • April 20, 2021

Thank you @Nate for your help :)