Best answer

Format of date received from Hubspot

  • 19 April 2021
  • 2 replies
  • 688 views

Userlevel 1

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.

icon

Best answer by Nate 19 April 2021, 15:37

View original

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

Userlevel 5
Badge +6

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 :) 

Userlevel 1

Thank you @Nate for your help :)