REQUIREMENT

In the All Tasks view, format condition like below
  • Highlight rows that due date tasks between last 7 days and next 7 days from today
  • Make it bold

DEFINE

  • Use operator Between on column Due Date (DateTime data type)
  • Use build-in function: ADD_DAYS in the Due Date column

RESULT in the All Tasks


Note

  • TODAY = 9/20/2016
  • ADD_DAYS(TODAY, -7) = 9/13/2016
  • ADD_DAYS(TODAY, 7) = 9/27/2016

ADD_DAYS(date, days)

  • return another date that plus/minus days
  • ADD_DAYS(TODAY, 7) = 9/27/2016
  • ADD_DAYS('9/20/2016', 7) = 9/27/2016

Last edited Sep 21, 2016 at 7:48 AM by phuocle, version 1