Date Time Variables
- Last UpdatedJun 25, 2024
- 3 minute read
The following datetime variables allow the user to filter datetime columns of the list:
All the datetime variables in this topic have been explained assuming the present date as 19th, month as January, and year as 2011.
Variable to filter datetime columns for Today
This variable is used to compare datetime columns for today. For example, the Support Manager wants to get all the incidents created today. To achieve this the Manager has to specify the Created DateTime variable equal to Variable.Sys.Today in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created today.
Variable System Current Week
This variable is used to compare datetime columns for the current week. For example, the Support Manager wants to get all the incidents created today. To achieve this the Manager has to specify the Created DateTime variable equal to Variable.Sys.Current Week in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created during the current week.
Variable System Last 10 days
This variable is used to compare datetime columns for the last 10 days. For example, the Support Manager wants to get all the incidents created during the last 10 days. To achieve this the Manager has to specify the Created DateTime variable equal to Variable.Sys.Last 10 Days in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created during the last 10 days.
Variable System Current Month
This variable is used to compare datetime columns for the current month. For example, the Support Manager wants to get all the incidents created this month. To achieve this the Manager has to specify the Created DateTime variable equal to Variable.Sys.Current Month in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created during this month.
Variable System Lasts 2 Months
This variable is used to compare datetime columns for the last 2 months. For example, the Support Manager wants to get all the incidents created during the last two months. To achieve this the Manager has to specify the Created DateTime variable equal to Variable.Sys.Last 2 Months in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created during the last 2 months.
Variable System This Year
This variable is used to compare datetime columns for the current year. For example, the Support Manager wants to get all the incidents created this year. To achieve this, the Manager has to specify the Created DateTime variable equal to Variable.Sys.This Year in the view creation window.
By specifying this variable, the user will be able to view all the support incidents created this year.
Date Range logic for each Date System variable
|
Variable |
From Date |
To Date |
|---|---|---|
|
Variable.Sys.Today |
Current date. |
|
|
Variable.Sys.Current Week |
Start date of current week. (Start of the week is as per the culture.) |
End date of current week. |
|
Variable.Sys.Last 10 Days |
10 days prior to current date. |
Current date. |
|
Variable.Sys.Current Month |
First day of current month. |
Last day of current month. |
|
Variable.Sys.Last 2 Months |
First day of the month which is two months prior to the current month. |
Last day of the month which is one month prior to the current month. |
|
Variable.Sys.This Year |
First day of the current year. |
Last day of the current year. |