list of dates between two fields?

[nelsonkh]

I am trying to figure out how to create a list of dates between 2 fields. I have a start date and an end date, is there a way to show in another field all of the dates between these two fields?

[bcooney]

If you had FM Advanced you could use the DateRange custom function. But, I'd rather explore why you feel the need to do this. Perhaps there's a better method to achieve your goal.

[nelsonkh]

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!

[bcooney]

You can find using date ranges. So, if you have a Start Date and End Date for each job, you can find records where Start Date >= Desired Date and End Date =< Desired Date.

[nelsonkh]

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.