Newbies Nousstars Posted October 25, 2016 Newbies Share Posted October 25, 2016 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. Link to comment Share on other sites More sharing options...
comment Posted October 25, 2016 Share Posted October 25, 2016 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" ) Link to comment Share on other sites More sharing options...
Newbies Nousstars Posted October 26, 2016 Author Newbies Share Posted October 26, 2016 yessss thangs thats it :-) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2831 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now