0 Replies Latest reply: Jan 22, 2018 5:22 PM by Bon Crowder RSS

    I need to filter by date, but want to do it right in the handy wizard.

    Bon Crowder

      I need to filter by date, but want to do it right in the handy wizard (not in the script). My field is a date-time field so I'm not sure how to "phrase" the filter. Any ideas?

       

      I'm using server_time < 8/15/2017, but there are 20 mil records, so it's going to take forever to try out many different possibilities do see which will work.

       

      Would love to just know.

       

      If nobody answers, I'll create new data (with only a few records) then sort on that to see what I can figure out and come back to answer my own question.

       

      fingerscrossed

       

      Thanks, y'all!