Can't search date in Britain format even after change the format

[isobelsoo]

HI all, 

I would like to have my date to show in dd/mm/yyyy instead of US format :

i. I change the language property of the Date picker to "en-GB"

ii. I change the format to "dd/mm/yyyy" in the Text property of the date on Browse Screen

However, I realize when I search on browse screen. I still need to search in US format. I screenshotted the last picture which show when I search 6/1... (which is 1st/10/11...June in US format) , the respective date are only be filtered. 

Can anyone help to show how I can filter/search in the Britain format instead of US on Browse screen?

[isobelsoo]

Hi @WarrenBelz , 

may i clarify am i supposed to paste the code above in Item property of browse screen?

[WarrenBelz]

@isobelsoo ,

Wherever you had the text you posted - I just modified it to add the date column in dd/mm/yyyy format and then search on that. I assume it is the Items of the gallery your are searching in.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[isobelsoo]

Hi @WarrenBelz 

Not sure why but the formula shows error

[WarrenBelz · Accepted solution]

Hi @isobelsoo ,

That does not help me much without knowing the error - I was providing syntax guidance more than anything and relying on your code posted, so going back to your original question, you want to search in dd/mm/yyyy format (I have only added a column here)

SortByColumns(
   If(
      Searchbox.Text<>"",
      Filter(
         AddColumns(      
            'BPC Power Apps Source Report',
            "MyDate",
            Text(Date,"dd/mm/yyyy")
         ),
         Or(
            Searchbox.Text in Category.Value,
            'Mixer No.'.Value=Searchbox.Text,
            Searchbox.Text in 'Product Item',
            Searchbox.Text in 'Batch No.',
            Searchbox.Text in 'Storage Tank No.'.Value,
            Searchbox.Text in Status.Value,
            Searchbox.Text in MyDate,
            Searchbox.Text in Shift.Value
         )
      ),
      'BPC Power Apps Source Report'
   ),
   "Date",
   If(
      SortDescending1, 
      Descending, 
      Ascending
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[isobelsoo]

hI @WarrenBelz ,

Thanks for your suggestion. The codes you suggested worked well to filter the date. However, I realized it seems to cause error in the browse screen which you can see the error pop up below. 

[isobelsoo · Accepted solution]

Hi all, 

Thank you so much for your time to help. 

I have somehow managed to fix it by adding the Text(Date."dd/mm"yyyy") in the Search function itself. 

Thank you! 🙂

[gabibalaban]

Hi @isobelsoo ,

Use for Item formula:

LookUp('BPC Power Apps Source Report',ID = BrowseGallery.Selected.ID)

I think that @WarrenBelz solved your initial request. 

[WarrenBelz]

Thanks @gabibalaban ,

Back in my time zone now - that is exactly how I do all my forms.