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!
Solved! Go to Solution.
Hello @LorenzoSP365 ,
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
)
Hello @LorenzoSP365 ,
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
)
@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.
@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!!