cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
isobelsoo
Helper II
Helper II

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

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?

capture6.png

 

capture5.png

Screenshot 2021-06-11 104909.png

17 REPLIES 17

Hi @WarrenBelz , 

 

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

 

@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.

 

Hi @WarrenBelz 

 

Not sure why but the formula shows error

isobelsoo_0-1623407068655.png

isobelsoo_1-1623407111587.png

 

 

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.

 

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_0-1623414783493.png

 

isobelsoo
Helper II
Helper II

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! 🙂

 

isobelsoo_0-1623415836877.png

 

Hi @isobelsoo ,

Use for Item formula:

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

I think that @WarrenBelz solved your initial request. 

Thanks @gabibalaban ,

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,181)