Stupid question calculation

[Nousstars]

I think i have a general misunderstanding.
but first things first
Filemaker 8.5 on Moc osx

I try to find a specific month in a date field.
so if i go to the search mode, i can simply type *.10.2016 and it works

so if i try to do this with a calculation field
and type
If ( date = *.10.2016"; " ok" ; "not OK" )
it don`t  work.

The only think that works is when i type a exact date like
If ( date = 12.10.2016"; " ok" ; "not OK" )

but how could i search just for a spesific monthe for instance.

[comment]

Wildcards work in search criteria, not in calculations. If you have a date field named Datefield, and you want your calculation to test for a specific month, use =

If ( Month ( Datefield ) = 10 ; "OK" ; "not OK" )

 

[Nousstars]

yessss thangs thats it :-)