Reference > Expressions > Built-in Functions > Date Functions > LastWeeks

LastWeeks

Returns the local date and time for a day that was a certain amount of weeks ago, based on the local time of the current session.

Syntax

LastWeeks(number)

Enabled for

Search/Dashboard Yes
Business Rules No
Quick Actions Yes
Workflow Objects No
Reports No

Parameter

number

The number of weeks to go back.

 

Note: If you enter a negative number, the function returns the local date and time for a date that is a certain number of weeks in the future, based on the local time of the current session.

Return Value

DateTime value.

If the system has to display the return value, it implicitly converts it to text, thereby allowing the display format to change depending on your culture code. See Available Languages and Cultures for a list of the culture codes used by HEAT.

Example

$(LastWeeks(3))

If today is April 10, 2014, the function returns the DateTime value for March 20, 2014.