Report with Date Range

[gilescis]

I have a report that prompts for date range of startdate and enddate. once ran, it takes the starttime and endtime and calculates total time per day. however if somone works on the last day of the month, it needs to only calculate the time up til midnight for that current month. Here is what I currently have:
DateDiff("n",{SchedulerPersonnelViewDetails.StartTime},{SchedulerPersonnelViewDetails.EndTime})/60

But if someone works over midnight on the last day of the month, it adds those hours to the time sheet which, anything after midnight would go on next months pay or timesheet.

Any help is greatly appreciated

 

[kevlray]

I have been thinking about this. I do not have a specific formula. But I would think you should be able to create a formula and any {SchedulerPersonnelViewDetails.EndTime} that is past the end of the month (use an if statement with a datediff). Then you could subtract off any time (minutes?) past the midnight time (using datediff to get the difference).

 

[gilescis]

Looking for some help on this or at least some sort of example

Thanks

 

[kevlray]

I wish I could help you, but I am tied up with projects right now. It definately will take some time to work up a solution (if one can be found).