<@U6Z208M32> you can use BETWEEN. Like `CASE WHEN ...
# suiteanalyticsj
jcribb
08/03/2018, 10:37 AM@samyt you can use BETWEEN. Like
CASE WHEN {yourdatefield} BETWEEN TO_DATE('07/26/2018', 'MM/DD/YYYY') AND TO_DATE('07/28/2018', 'MM/DD/YYYY') THEN 'T' ELSE 'F' END👍 1
s
samyt
08/03/2018, 10:41 AMWow. you have answer for everthing in saved search