Jump to content

list of dates between two fields?


This topic is 5588 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I work for a construction company and we have jobs that last about 3 - 5 days on average. My managers would like to be able to see what days we worked on jobs, but I was thinking that if we used a field that showed us a list we could also search for all jobs worked on during a given day. So, if a job starts on Monday and ends on Friday, if I run a report for all jobs active on Tuesday, Wednesday or Thursday the job would come up on the list. Any suggestions for better ways around this would be appreciated!

Link to comment
Share on other sites

Ah yes, sorry that's pretty obvious isn't it!

Another thing we were hoping to be able to calculate is job cost per day for our installers. Not sure what a good solution to this would be. If a job lasts 3 days and our crew works varying hours per day, we would like to be able to capture what those hours are and also per person.

Link to comment
Share on other sites

This topic is 5588 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.