Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case
- when [Appt_Date] between (current_date) and _add_days (current_date,-7) then 1 else 0
- end
- case
- when [Appt_Date] between _add_days(current_date,-8) and _add_days (current_date,-14) then 1 else 0
- end
- case
- when [Appt_Date] between _add_days (current_date,-15) and _add_days (current_date,-21) then 1 else 0
- end
- case
- when [Appt_Date] between _add_days (current_date,-22) and _add_days (current_date,-28) then 1 else 0
- end
- case
- when ([Appt_Date] > _add_days ({current_date},-28)) then 1 else 0
- end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement