Edit

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:

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