MoneyWorks Manual
PeriodOffset (period, offset)
Result Type: period
Definition: Returns the period number that is offset periods from period. Because periods are based on (Year * 100 + period), you can’t just subtract 1 from a period number to give you the previous period (e.g. in the 12 period financial year the last period for year 5 is 512; the following period is 601).
Examples: PeriodOffset(CurrentPer, -6)
returns the internal number of the period that is 6 periods before the current period.
See Also:
CalcDueDate: Calculate a due date for given terms
CurrentPeriod: Get the current period number
Date: Convert d,m,y to a date
DateToPeriod: Convert a date to a period
DateToText: Format a date as a string
Day: Get the Day of month of a date
DayOfWeek: Get The weekday of a date
FirstUnlockedPeriod: Get the oldest period that is not locked
Month: Get the month of a date
PeriodName: Get the Name of a period
PeriodToDate: Get the end date of a period
TextToDate: Parse a string to a date
Time: The current Datetime
TimeAdd: Add seconds to a DateTime
TimeDiff: The difference, in seconds, between two DateTimes
Timestamp: A timestamp string
Today: Today's date
WeekOfYear: Convert a date to a week number
Year: Year of a date