Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Less than or Equal(<=) is not working correctly on date column filter

Hi Developers,   I have a requirement to fetch the most recent dated record based on a date. The parameter date, I am passing it from a dropdown and I am passing only the date so by default the tim...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago

In case you need to filter the date column entries in a SharePoint List, you also need to consider about the exact entry time.

 

Thus, if you need to take all the list items before a specific date, you must use the following function in your case:

 

<= DateTimeValue(Text(Dropdown2.Selected.'Start Date') & " 23:59:59")