Not Recognizing Date issue

1

Project Name (if applicable, otherwise just type n/a)

Question

The entries titles (Kirkos Hilton Primary Clinic 14, Kirkos Radisson Primary Clinic 14, Kirkos Sunshine Clinic 14, and Kirkos Huderma Dermatology Specialty Clinic 14) all have a creation date of 07/04/2026, but when I integrate them into Google Sheets, the date is not recognized as a valid date format. Why is this happening?
Thanks in advance

I confirm I have read the User Guide at docs.epicollect.net

on

I confirm I have searched for an answer in this community.

on

I confirm I have tried asking the same question to Perplexity AI with the tag #epicollect5, but it did not help.

on

2

Google Sheets likely treats “07/04/2026” as text, not a date, due to a locale mismatch.

Or hidden characters/spaces from Epicollect5 export prevent recognition.

Quick Checks

  • Select cell: If =ISDATE(A1) returns FALSE, it’s text.​

  • File > Settings > Locale: Set to a locale for DD/MM/YYYY.

Fixes

  • Formula: =DATEVALUE(A1) or =TO_DATE(A1) in new column.​

  • Data > Split text to columns (delimiter “/”), then Format > Number > Date.​

  • Multiply by 1: Enter =A1*1 to force number/date conversion.