Jump to content
Sign in to follow this  
nelsonkh

list of dates between two fields?

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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