cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pankaj2125
Frequent Visitor

Datepicker not showing data before a week

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.

1 ACCEPTED SOLUTION

Accepted Solutions

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

vbofengmsft_0-1639983299387.jpeg

 

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

View solution in original post

3 REPLIES 3
PowerAddict
Super User
Super User

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

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

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

vbofengmsft_0-1639983299387.jpeg

 

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

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 (6,119)