Datepicker not showing data before a week

[pankaj2125]

Hi All,

I am using Datepicker to filter/see data for a particular day. But when i am choosing a date before last monday(6th Dec 2021), its not showing any data.

Source of my app is sharepoint list.

Is there any limitation as such ? Please suggest.

[PowerAddict]

Hi @pankaj2125 , 

What is your formula to show records based on the date selected in the date picker? Are you sure there is data that should be visible when an older date is selected?

---
If you like this reply, please give kudos (Thumbs Up). And if this solves your problem, please mark this reply as a solution by selecting Accept as Solution. This makes it easier for others to find answers to similar questions. 

Thanks!

Hardit Bhatia

Microsoft Business Applications MVP

Microsoft Certified Trainer MCT

Blog | Twitter | LinkedIn | Facebook | YouTube  |  Email

[pankaj2125]

This is the formula i am using while doing filter in gallery.

[v-bofeng-msft · Accepted solution]

Hi @pankaj2125 :

This may be caused by time zone issues.The point is that your device and SharePoint Site are not in the same time zone.

There are two solutions:

Solution1:Set your SharePoint time zone to the time zone of your current device

Solution2:Add a date offset to the search criteria

For example:

 Created >= DateAdd( DatePicker1.SelectedDate,X,Hours)

 &&

Created  <DateAdd( DateAdd(DatePicker1.SelectedDate,1,Days),X,Hours)

Best Regards,

Bof