Wildmatch on dates in two fields

[sibrulotte]

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

[MK_QSL]

is wildmatch5() still exists?

[sibrulotte]

Yes,

Working on QV 11.20.12235 SR5

[MK_QSL]

wildmatch() and wildmatch5()

[sibrulotte]

Both