Searching dates using native search box in views

AppSheet AppSheet Q&A
1

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

2

I believe it’s by design and locale settings don’t have an effect on the search process.

2 Likes
3

Thanks Levent. It seems the users should perform the date search using mm/dd/yyyy format.

Cheers

1 Like
4

LeventK:

locale settings don’t have an effect

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

1 Like
5

I wish the text function would allow to format numbers other then dates e.g. TEXT( value, format )

1 Like