October 25, 20169 yr Newbies 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.
October 25, 20169 yr 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" )
Create an account or sign in to comment