web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Date Difference

Power Apps

Answered

Date Difference

(0) Share

Report

Report

Posted on by Kaschlegel

48

I have two date pickers (startdate, enddate).

Where would I fit the datediff into this string, please? Thanks for whatever

knowledge you can share.

Sort(
 AddColumns(
 GroupBy(
 'FLMA Tracking',
 "Dept",
 "Station",
 "OtherData"
 ),
 "Hours",
 Sum(OtherData,HoursUsed)
 ),
 Station
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Kaschlegel

You've not provided a lot of detail on what you are trying to do, so I will just assume you are using datepickers to filter out a range of dates from the results of your table.

If so, then the following formula should assist.

Sort( AddColumns( GroupBy( Filter('FLMA Tracking', dateCol >= startDate.SelectedDate && dateCol <= endDate.SelectedDate ), "Dept", "Station", "OtherData" ), "Hours", Sum(OtherData,HoursUsed) ), Station )

I hope this is helpful for you.
WarrenBelz 156,566 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kaschlegel ,

You did not specify the field, but it would go in here

Sort( AddColumns( GroupBy(
Filter( 'FLMA Tracking',
DateDiff( . . . .
), "Dept", "Station", "OtherData" ), "Hours", Sum(OtherData,HoursUsed) ), Station )

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.

Join the conversation