Return to FileMaker.com
Why I can not get the right Date with Date formula
i import Excel file into FM, the date format is "12/30/2010". but , I did not know how to get the right year to complete the conditional format.
For examples: year(PGI date) >2010, what is right formula.
Thank you for your post.
Year (PGI date) > 2010
is the correct formula. What is the calculation you are trying to display?
Also, check to make sure "PGI date" is a Date field. Otherwise, the formula will not work. Return to Manage -> Database... and check to make sure PGI date is a Date field. If not, change it.
Retrieving data ...