3 Replies Latest reply on Jan 31, 2017 12:57 PM by Charley Saint

    Date Variable Compare in Search Not Working (PDM 2016)

    Casey Dixon

      Hi,

       

      Hoping for some help as this is driving me insane.

       

      I've got a date variable stored on cards and I want to be able to run a search between date bounds, ie. Greater than 30 Jan 16, but Less than 01 Mar 16.

       

      On the Variable tab of the search, there is an option to search specifically by date comparisons but these turn up empty searches with Greater, equal and Less. If I search for text equal to, I can isolate files with a single date but this will not be efficient. 

       

      The only thing I can think of is that date format is not of a standard numerical format so PDM isn't able to search correctly.This makes no sense however, as I am able to correctly sort the results column by date when I apply no date conditions to the search. Also, at this stage it will be too difficult to update the date format of the vault if it is indeed the issue.

       

      Thanks