cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbgoh
Helper V
Helper V

Count rows with a day

Hi,

 

I wish to countrows of a Sharepoint list with one day i.e. Now() 00:00:00 to Now() 23:59:59. However I am unable to get the formula correct. The field I am checking against is a sharepoint datetime field. Any advise?

 

CountRows(
Filter(
SP_LIST,
'Issue Date' >= DateTimeValue(Now(), "dd/mm/yyyy 00:00:00.fff"),
'Issue Date' <= DateTimeValue(Now(), "dd/mm/yyyy 23:59:59.fff")
)

1 ACCEPTED SOLUTION

Accepted Solutions
UdayAdhikari
Responsive Resident
Responsive Resident

@sbgoh - please give this a try. By default, DateDiff function uses "Days" to compare between 2 dates so it ignores times.

 

CountRows(
    Filter(
        SP_LIST,
        DateDiff(
            'Issue Date',
            Today()
        ) = 0
    )
)

 

Thanks

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

2 REPLIES 2
UdayAdhikari
Responsive Resident
Responsive Resident

@sbgoh - please give this a try. By default, DateDiff function uses "Days" to compare between 2 dates so it ignores times.

 

CountRows(
    Filter(
        SP_LIST,
        DateDiff(
            'Issue Date',
            Today()
        ) = 0
    )
)

 

Thanks

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

It works. Thank you!

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (63,429)