Filtering by Dates
To filter issues by date, the render variables automatically contain the following date constants. These are generally straightforward. The constant begin refers to the first second of the specified date or range, while end signifies the final second of that particular period.
today
tomorrow
yesterday
thisWeek
thisMonth
lastMonth
thisYear
thisQuarter
previousQuarter
beginOfToday
endOfToday
beginOfTomorrow
endOfTomorrow
beginOfYesterDay
endOfYesterDay
beginOfThisWeek
endOfThisWeek
beginOfNextWeek
endOfNextWeek
beginOfLastWeek
endOfLastWeek
beginOfThisMonth
endOfThisMonth
beginOfNextMonth
endOfNextMonth
beginOfLastMonth
endOfLastMonth
beginOfThisYear
endOfThisYear
beginOfNextYear
endOfNextYear
beginOfLastYear
endOfLastYear
beginOfQuarter
endOfQuarter
beginOfPreviousQuarter
endOfPreviousQuarter
You can reference specific dates using a text description and then convert it to a real date using the dates.get expression function. The following are examples of valid expressions:
//same as beginOfQuarter:
dates.get("Start of this quarter")
// same as endOfQuarter
dates.get("End of this quarter")
Use the following method to get a specific date. In this example, the 1st of September in 2014 will be returned:
dates.get(2014, 9, 1)
Use the past() function to get a relative date from today. In this example, the function will get the day that was 180 days ago:
dates.past(180)
To create a date using the current default date or datetime format use the following function:
// parses date or datetime
dates.parse("Sep 01 2014")
// parses only date, ignores time
dates.parseDate("Sep 01 2014")
// parses a date with time
dates.parseDateTime("Sep 01 12:34 2014")