Q: Columns is not recognizing a valid date format??

When I connect my Google Sheets file to Columns, it is not recognizing the date column as a valid Time series. Why is that?? The current format is "05-20-2025". The schema is only seeing it as text. According to the documentation, this is a valid format (UsDateFull: 'M/d/yyyy', 'MM/dd/yyyy').

newlifecccPLUSMay 23, 2025
Founder Team
ShawnCao

ShawnCao

May 24, 2025

A: We will use support channel to analyze your data and see why DATE is not recognized, based on what you provided, it should.

Share
Helpful?
Log in to join the conversation
Founder
Posted: May 23, 2025

You are right, that’s a valid date, it should work. But do all values follow the correct format?

Can you share your sheet with me to test? Can send email or live chat.

Verified Purchaser badge

Verified purchaser

Posted: May 23, 2025

Yes, I can share. Please send me your email address. Thanks

Founder
Posted: May 24, 2025

Please click "Email" from this page - https://columns.ai/contact to get in touch through email.