this feels like it should be easy but i can't quit...
# suiteanalyticsa
amy
02/21/2019, 10:00 PMthis feels like it should be easy but i can't quite get there - anyone know off the top of their head a way to have a filter comparing two dates? I want my search to return values if date1 is after date2. i've tried using date1 > date2 and (date1-date2) > 0 and keep getting errors.
a
Ankur Sanghi
02/22/2019, 2:38 AMI have used date comparison in filter criteria by using it inside a formula (numeric) ... case when {date1} > {date2} 1 else 0 end and then filter for 1
a
amy
02/22/2019, 4:56 PMhuh, that's basically what i had - maybe i had a typo or something, i'll try it again. thanks!
amy
02/22/2019, 8:36 PMi had forgotten to put "end" at the end 🤦 working now, thanks again!
a
Ankur Sanghi
02/22/2019, 9:14 PMOne of those times that you stare at it for hours for the most obvious answer! the curse of being into programming...
2 Views