Hi there,
I haven't started the database yet but i'm wondering if it's possible to add date ranges together to get a total number of days. For example : If a person worked on a particular task from 1/1/19 to 6/1/19 and again on 2/3/19 to 7/3/19 and then again from 4/6/19 to 13/6/19....would it be possible to design a query to work out the total number of days the person spent on that task ?
I wasn't sure if this could be done with a query so i put it in this section.
Ps...the table would contain a StartDate and EndDate field to reflect the start and finish dates on each occasion
Thanks (Dates in UK format)
I haven't started the database yet but i'm wondering if it's possible to add date ranges together to get a total number of days. For example : If a person worked on a particular task from 1/1/19 to 6/1/19 and again on 2/3/19 to 7/3/19 and then again from 4/6/19 to 13/6/19....would it be possible to design a query to work out the total number of days the person spent on that task ?
I wasn't sure if this could be done with a query so i put it in this section.
Ps...the table would contain a StartDate and EndDate field to reflect the start and finish dates on each occasion
Thanks (Dates in UK format)