RentDateSwitch | ||||||||
Data Type: Float | ||||||||
A floating point (ie not an integer) number.If the value is a string, the function will attempt to convert it to a number, using the part of the string from the start to the first non-numeric character (ie not one of 0123456789+-*/^). | ||||||||
Specify the "n-th next" and "n-th last" date Where the indicator is relating to the next or last date, you can additionally look beyond the immediate next or last date by using a number after the decimal point. For example: 3 = Next Lease Start Date 3.1 = Next but 1 lease start date (ie skip the next lease start date and return the one after that) 3.2 = Next but 2 lease start date. etc Up to 9 "next-but"s are possible. | ||||||||
Example: 1 | ||||||||
Variable Values | ||||||||
Default(s) | ||||||||
0 | Next Review | |||||||
Switches | ||||||||
0 | Next Review | |||||||
1 | Last Review | |||||||
2 | Next Lease Start Date | |||||||
3 | Last Lease Start Date | |||||||
4 | Next Rent Start Date | |||||||
5 | Last Rent Start Date | |||||||
6 | Next Expiry | |||||||
7 | Last Expiry | |||||||
8 | Next Break | |||||||
9 | Last Break |