Robbyp2001
Registered User.
- Local time
- Today, 15:55
- Joined
- Oct 8, 2011
- Messages
- 143
Hello folks
I wonder if anyone can advise me as to how to address the following problem:
On a form I have to input a [StartDate] and an [EndDate]
The underlying query then calculates the total number of days between these dates [DaysWorked].
This works so far.
What I would like to do next is, from the number [DaysWorked] calculate the number of full years and display this in a box
and
Calculate the number of days in addition to a full year and display that in a different box.
Example:
[StartDate] Input = 12/11/2015
[EndDate] Input = 11/05/2019
[DaysWorked] Calculated = 1276
[FullYears] Calculated = 3
[DaysOver] Calculated = 181 (I think)
If I can calculate [FullYears] and [Days Over] and isolate them separately I can then use these for other calculations.
Is such a thing possible?
I know if it is, someone on here will know for sure!
I wonder if anyone can advise me as to how to address the following problem:
On a form I have to input a [StartDate] and an [EndDate]
The underlying query then calculates the total number of days between these dates [DaysWorked].
This works so far.
What I would like to do next is, from the number [DaysWorked] calculate the number of full years and display this in a box
and
Calculate the number of days in addition to a full year and display that in a different box.
Example:
[StartDate] Input = 12/11/2015
[EndDate] Input = 11/05/2019
[DaysWorked] Calculated = 1276
[FullYears] Calculated = 3
[DaysOver] Calculated = 181 (I think)
If I can calculate [FullYears] and [Days Over] and isolate them separately I can then use these for other calculations.
Is such a thing possible?
I know if it is, someone on here will know for sure!