You’re offline. This is a read only version of the page.
29
Hello,
I am building an app to record time. There is a field for "Project", "Start", and "End".
I have created a gallery to group all items where the project is the same (that match a date picker):
GroupBy(Filter('Time Recording', Start >= dprDateFrom.SelectedDate && Start <= dprDateFrom.SelectedDate + 7), "Project", "grpProject")
I then need to show the number of hours recorded for each day for each project:
I assumed that I would use DateDiff for the "Start" and "End" fields and possibly Sum them, but that doesn't work (I tried this "Text(Sum(ThisItem.'Work Order', DateDiff(Start, End, Hours)), "[$-en-US]hh:mm:ss")").
Any suggestions would be greatly appreciated.
Thanks!
Ryan
I have found a solution for this, just incase anyone has the same issue. Not sure if it is the best way to approach it but I was able to use the "with" function" and then Sim the DateDiff.
Thanks!
Share
Report
All responses (
Answers (
