Adhoc Report Schedule UI

Schedule any report for daily, monthly, weekly, yearly frequency or one time.

 

Custom Dates:

Token Description
BEGIN_OF_PREV_DAY The beginning of the previous day
BEGIN_OF_DAY Beginning of current day
BEGIN_OF_NEXT_DAY The beginning of next day
END_OF_PREV_DAY End of the previous day
END_OF_DAY End of the current day
END_OF_NEXT_DAY End of the next day
BEGIN_OF_PREV_WEEK The beginning of the previous week (Week Start Sunday 00:00)
BEGIN_OF_WEEK The beginning of the current week 
BEGIN_OF_NEXT_WEEK The beginning of the next week
END_OF_PREV_WEEK End of previous week (Week End Saturday 23:59)
END_OF_WEEK End of current week
END_OF_NEXT_WEEK End of next week
BEGIN_OF_PREV_MONTH The beginning of the previous month 
BEGIN_OF_MONTH The beginning of the current month
BEGIN_OF_NEXT_MONTH The beginning of the next month
END_OF_PREV_MONTH End of previous month
END_OF_MONTH End of current month
END_OF_NEXT_MONTH End of next month
BEGIN_OF_PREV_YEAR The beginning of the previous year
BEGIN_OF_YEAR The beginning of the current year
BEGIN_OF_NEXT_YEAR The beginning of the next year
END_OF_PREV_YEAR End of previous year
END_OF_YEAR End of current year
END_OF_NEXT_YEAR End of next year
BEGIN_OF_PAST_QUARTER Beginning of the past quarter
END_OF_PAST_QUARTER End of the past quarter
BEGIN_OF_PAST_HALF_YEAR Beginning of past half year
END_OF_PAST_HALF_YEAR End of past half year
DATE(year, month, day) Specific date. Example: DATE(2015,6,30)
DATETIME(year, month, day, hour, minute) Specific date and time. Example: DATETIME(2015,6,30,10,30)
YEAR(+/- number, BEGIN/END) Get date by adding or subracting years from current date. Example: YEAR(2) adds 2 years, YEAR(-2) subtracts 2 years, YEAR(2, BEGIN) adds 2 years and goes to 1 january 12 AM of that year, YEAR(2, END) adds 2 years and goes to last minute of that year which is 11:59pm of 21st december.
MONTH(+/- number, BEGIN/END) Get date by adding or subracting months from current date. Example: MONTH(2) adds 2 months, MONTH(-2) subtracts 2 months, MONTH(2, BEGIN) adds 2 months and goes to 1st minute of that month, MONTH(2, END) adds 2 months and goes to last minute of that month.
WEEK(+/- number, BEGIN/END) Get date by adding or subracting weeks from current date. Example: WEEK(2) adds 2 weeks, WEEK(-2) subtracts 2 weeks, WEEK(2, BEGIN) adds 2 weeks and goes to 1st minute if that week, WEEK(2, END) adds 2 weeks and goes to last minute of that week.
DAY(+/- number, BEGIN/END) Get date by adding or subracting days from current date. Example: DAY(2) adds 2 days, DAY(-2) subtracts 2 days, DAY(2, BEGIN) adds 2 days and goes to 1st minute if that day, DAY(2, END) adds 2 days and goes to last minute of that day.
 

Rating: