Advertisement
Guest User

Untitled

a guest
Aug 25th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. case
  2. when [Appt_Date] between (current_date) and _add_days (current_date,-7) then 1 else 0
  3. end
  4.  
  5. case
  6. when [Appt_Date] between _add_days(current_date,-8) and _add_days (current_date,-14) then 1 else 0
  7. end
  8.  
  9. case
  10. when [Appt_Date] between _add_days (current_date,-15) and _add_days (current_date,-21) then 1 else 0
  11. end
  12.  
  13. case
  14. when [Appt_Date] between _add_days (current_date,-22) and _add_days (current_date,-28) then 1 else 0
  15. end
  16.  
  17. case
  18. when ([Appt_Date] > _add_days ({current_date},-28)) then 1 else 0
  19. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement