Hi Everyone,
I am trying to search dates in a column where its type is date and locale is Turkey (dd/mm/yyyy) using the native search box. I figured out that I can only search the dates if I enter the date I am searching in mm/dd/yyyy format. Both the Google Sheetsโ and tableโs locale is Turkey. This is rather confusing for the end user who wants to search a date using the search box. Is there a way to solve this? Or did I by some luck catch a โbugโ?
Cheers,
Neลet
I believe itโs by design and locale settings donโt have an effect on the search process.
Thanks Levent. It seems the users should perform the date search using mm/dd/yyyy format.
Cheers
Based on the findings in one of my apps, I can confirm that the search bar unluckily disrespects locale settings when it comes to dates.
As a workaround, I am thinking of a virtual helper column that calculates a string in the form of the expected locale dd/mm/yyyy
TEXT([Date], "dd/mm/yyyy")
โ thanks @Steve for the hint!
However, when the user searches e.g. for Dec 1st and enters โ1/12โ instead of โ01/12โ, 11th Dec, 21 Dec and 31 Dec also show up if present in the table
I wish the text function would allow to format numbers other then dates e.g. TEXT( value, format )
User | Count |
---|---|
42 | |
33 | |
24 | |
23 | |
14 |