Date filter

(1) Share

Report

Posted on by SD-24111144-0

Hello,

I have a sharepoint list with a date and time column.

I also have a gallery where I can view the data added from within the sharepoint.

However when I add the dates, it will not bring up the data for when I select the last date. So if I just want to select the one day it will not work. Any idea how to resolve? What have I done wrong here?

Categories:

General Questions

I have the same question (0)

All responses (3)

Answers (0)

MS.Ragavendar 4,601 Super User 2025 Season 2 on at

Like (0)

Report

Date filter

@SD-24111144-0,

You haven't specify the backend schema, If the referring SharePoint column having data type of Date & time try with StartOfDay/EndOfDay.

And(
'Course date' >= StartOfDay(dpicker1.SelectedDate),
'Course date' <= EndOfDay(dpicker2.SelectedDate)
)

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

1 people found this reply helpful.

Was this reply helpful? Yes No
SD-24111144-0 4 on at

Like (0)

Report

Date filter

@MS.Ragavendar

Was this reply helpful? Yes No
SD-24111144-0 4 on at

Like (0)

Report

Date filter

@MS.Ragavendar

Thank you for this but sorry but not sure where to put this part of the formula

Very new to all this and first time building, any help is appreciated

Was this reply helpful? Yes No