Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Filtering Based on the Starttime, EndTime

I am Filtering SharePoint List to display records only for that Day alone. I am Storing StartTime as datetime column in SharePoint in the format dd/mm/yy 00:00 format . In the PowerApps when I use Today() , it is showing todays date and 12:00:00 am as Time . and Filtering Values Start Time(Today()) is not fetching all the values . So I am using like this 

With( { StartDate: DateTimeValue(Today()-1), EndDate: DateTimeValue(Today()+1)}, Filter( CallDetailsList,StartTime > StartDate, StartTime <= EndDate ) )

Though it seems to be weird ,But this is only fetching values . But Still I could see some of the Values at the Start of the day (8:00 to 5:00 working hours), it is not fetching values . 

Can Someone Help me with the better formula , SO that I can use this to fetch only Today business Hours Record 

 

TIA

1 Reply

  • ND_Pard's avatar
    ND_Pard
    Helper II
    3 years ago

    Hope this helps.

    In Excel, the Today() function returns a number that will return today's date with a time of 12:00 AM; i.e., it returns a whole number without a fraction.  Example:  3/27/2023 12:00 AM

    The Now() function returns not only the number for today's date, but also a fraction which represents time.

    Example: 03/27/2023 5:10 PM

     

    Good Luck.