SharePoint List not showing items - Date Issues

[Anonymous]

Hello everyone! I have created 4 SP Lists that all contain a date field. I have set up the gallery for each list so that the data will only display when the date picker selected = A date in each of the SP lists. (Each Gallery has a similar Filter.)

It works for all dates except for the single digit day dates that contain a zero in the front. The format for each date field in the SP List is "mm/dd/yyyy".Examples below:

Any bit of help will be appreciated!

[WiZey · Accepted solution]

Hello @Anonymous ,

Have you tried this format?

Text(DatePicker.SelectedDate; "m/dd/yyyy")

In your filter it would look like this:

Filter(
  source,
  Text(DatePicker.SelectedDate; "m/dd/yyyy") in Title
)

[Anonymous]

@WiZey Thank you for responding. However, now the complete opposite is happening. All dates with single day dates (ie. 7/03/2022) show up but any double digit days (ie. 7/12/2022) do not show.

[Anonymous]

@WiZey I went into the SP lists to make sure that single digit dates like 7/7/2022 or 12/7/2022 were changed to 07/07/2022 and 12/07/2022. Still using your  formula, I just changed the date format to mm/dd/yyyy and it's working perfectly! Thank you!!