Creator Help

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

Share this post : FacebookTwitter