V18 - Unit location code (Unit Sales Report Generator variable)
Syntax
V18{D1-D16, L/S}
Description
The location code of the unit.
If you want the location of a unit at a given date, use the parameter below. Note the starting date of the date range given will be used.
Parameters
- 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.
- L/S
- A text parameter that can be omitted (it defaults to "L").
- L
- Returns the location code.
- S
- Returns the site code for this location.
Returns
A text value whose typical size is 3 characters.
