1 Reply Latest reply on May 11, 2017 3:58 PM by purusottam nayak

    How can 'incomplete' dates be handled in IIR matching?

    New Member

      If you have a system that needs IIR to do matching on names and dates, eveything is fine when you have actual full dates.

      However, one of our sources sends us dates as strings in the dd/mm/yyyy format.  When one of the 3 is missing, they subsitute it with a '-' (since the datatype is a string, not date).  So if all they have is 'June 2000', that date will come in as "--/06/2000".

      Is this something that IIR can handle?  If so, what's the best way of doing it?

      (I can think of a pretty ungraceful way of breaking up evey date into components and building string comparisons, but that'd be pretty horrible)