4 Replies Latest reply: Jul 17, 2015 11:13 AM by Simon Brulotte RSS

    Wildmatch on dates in two fields

    Simon Brulotte

      Hi,

      if a date selected in the field [Date_calcul] exists in all of the values in [Date calcul] I'd like a 'Yay'.

       

      Here a re my miserably failing attempts as of now

      (and yes both dates exists in the form 2015-07-13 00:00:00)

       

      =if(wildmatch5([Date calcul],only([Date_calcul])),'yay','nay')

      gives

      'nay'

       

       

      =if(wildmatch5([Date calcul],'*$(=only([Date_calcul]))*'),'yay','nay')

      gives

      'nay'

       

       

      EDIT:

      =if(wildmatch5(concat(distinct [Date calcul],'|'),'*$(=only([Date_calcul]))*'),'yay','nay')

       

      Gives me 'yay'

      figured it out before pressing Post, but I figured I'd share for common knowledge