L09 - Workshop hours (Unit Workshop Report Generator variable)
Syntax
L09{0-7, D1-D16, T/A/U/C}
Description
The number of workshop hours by time period, The types of workshop hourly information available are : available hours, attended hours, used hours or charged hours depending on parameters set.
Parameters
- 0-7
- A text parameter that can be omitted (it defaults to "0").
- 0
- Available hours on the whole week.
- 1-7
- Available hours for a given day.
- 1
- Sunday.
- 7
- Saturday.
- D1-D16
- A text parameter that can be omitted.
- Restrict to a given date range.
- D1-D16
- Corresponds to the date range screen.
'D1+1D' where 'D1' is the "date range" and '+1D' is the "date modifier". |
This date range can be modified by using one of the following date modifiers after the date indicator. |
Date Modifiers
With offset
Eg. '+1D', '1Y', '-1Y'
- D
- Days
- M
- Months
- Y
- Years
If you want to add a unit to the date then you should just use the number you want to add and if you want to subtract the units from the date just use a '-' before the number.
A combination of units can be used. E.g. '-1Y+1M' would subtract 1 year and then add 1 month. Of course you could just subtract 11 months ('-11M'). |
'Month' will be used as default. E.g. '+2' will be interpreted as '+2M' and '-2' as '-2M'. |
Without offset
Eg. '+', 'D', '='
- =
- User Date
- .
- Machine Date
- -
- Previous Day
- +
- Next Day
- M
- First day of the current month.
- H
- Last day of the current month.
- Y
- First day of the current year.
- R
- Last day of the current year.
- W
- First day of the current week (Mon).
- K
- Last day of the current week (Sun).
A combination of units can be used. E.g. '=--' would subtract 2 days from the current user date. Another way to write that would be '=-2D'.
|
Note
If you are using the year or month units you should note if the date supplied was the last day in a month that doesn't exist in the new year calculated the last day in the new month will be used. So don't worry if you add one year to a february date that was set to the last day of that february. The 29th of february in a leap year would be converted to the 28th of february in the new calculated year, unless of course you were adding a multiple of four years to the date, in this case the 29th february would be kept.
- T/A/U/C
- A text parameter that can be omitted (it defaults to "T").
- Hours source.
- T
- Theoretical.
- A
- Attended.
- U
- Used.
- C
- Charged.
Returns
A numeric value whose typical size is 4 digits plus 2 decimal places.