0

In share point lists, How to find if the record was created between 10 AM yesterday to 11 AM today ?

Need this for List->View ->Filter and also to check in Power automate to see if the record is eligible for processing.

0

Here're steps:

1.Create a calculated column by using below formula first.

=TEXT(Created-DATE(YEAR(Created),MONTH(Created),DAY(Created)),"hh:mm")

2.Create two views.One view filter 10 AM to 24 PM yesterday,another 0 PM to 11 AM today.

First view:

enter image description here

Second view:

enter image description here

| improve this answer | |
  • Why do we need two views ? If there are 2 view how could it be combined so that the current view is a combined one..object is to show records that was created between 10 AM yesterday to 11 AM today. This should happen daily and we cannot hard code the date in condition – skpraveen May 21 at 4:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.