Date Constants

Given below is a list of date variables that can be used as Deluge criteria in a report. ( List, summary, grid or calendar report formats ) For example, to get records added in last 7 days the criteria added to the view should be ADDED_TIME in last 7 days

FunctionDescription
 LAST WEEK Returns the date between start and end of previous week
 LAST MONTH Returns date between start and end of previous month
 LAST YEAR Returns records between start and end of previous year
 THIS WEEK Returns date between start and end of current week
 THIS MONTH Returns date between start and end of current month
 THIS YEARReturns date between start and end of current year
 NEXT WEEK Returns date between start and end of current week
 NEXT MONTH Returns date between start and end of next month
 NEXT YEAR Returns date between start and end of next year
 LAST n DAYS Returns date for last n days excluding today
 LAST n WEEKS Returns date for last n weeks excluding current week
 LAST n MONTHS Returns date for last n months excluding current month
 LAST n YEARS Returns date for last n years excluding current year
 NEXT n DAYS Returns date for next n days excluding today
 NEXT n WEEKS Returns date for next n weeks excluding current week
 NEXT n MONTHS Returns date for next n months excluding current month
 NEXT n YEARS Returns date for next n years excluding current year
 n DAYS AGO Returns date for the duration of one day starting from n days before today
 n WEEKS AGO Returns date for the duration of one week starting from n weeks before current week
 n MONTHS AGO Returns date for the duration of one month starting from n months before current month
 n YEARS AGO Returns date for the duration of one year starting from n years before current year