How to keep UK Date format to Google Sheets | Community
Skip to main content
Answered

How to keep UK Date format to Google Sheets

B

Hi, 

We have a date question that is linked to Google Sheets.  

 

On the typeform the format is UK. 

When connected to Google Sheets it inserts as US format, even when the destination column is set at UK format.  

Can anyone help with this.

 

Thanks 

Best answer by Liz

Hi @Ben Curry Thanks for stopping by! Our API sends the data to Google Sheets in the UTC format, which is why you’re seeing the date appear as it is. While we don’t have an option to change the output of the date, you could setup a formula within Google Sheets to change this automatically for you. 

This post here might help you with editing the data: 

Let me know if you think of any other questions!

View original

2 replies

Liz
Community Team
Forum|alt.badge.img+5
  • Liz
  • Tech Community Advocate
  • 15008 replies
  • Answer
  • August 12, 2021

Hi @Ben Curry Thanks for stopping by! Our API sends the data to Google Sheets in the UTC format, which is why you’re seeing the date appear as it is. While we don’t have an option to change the output of the date, you could setup a formula within Google Sheets to change this automatically for you. 

This post here might help you with editing the data: 

Let me know if you think of any other questions!

Life is a series of awkward moments separated by snacks.
john.desborough
A
2 people like this
  • john.desborough
    john.desborough
  • A
    Adeniji Alex
A
  • Adeniji Alex
  • Navigating the Land
  • 1 reply
  • December 20, 2021

BIUE

 

Reply


Still need help?

Don't be shy and ask the community.

Ask your question here!
Community T&Cs