3 Replies Latest reply on Aug 22, 2017 8:03 AM by Joe Oppelt

    Why will the date filter not work?

    Jonah Margolis

      I have converted a date from EPOCH using the calculated field below:

      DATE(DATEADD('second', INT(([Statustime.Timesenttosubmitted])/1000), #1970-01-01#))

       

      When try to filter the date all data disappear. Does anyone know why everything disappears?

       

      I have attached the workbook. I am trying to filter tab 2.