I have two tables with date fields. One table had a full date field. The other field has a month and year field. I need to pull some data from the second table but I am having problems with the formula. Here is what I have so far:

NumberVar ProductsGoal;


If  {GoalsWithProductSummary.goalmonth} = Month{DriveMaster.FromDateTime} and {GoalsWithProcedureSummary.goalyear} =
Year{DriveMaster.FromDateTime}
Then
ProductsGoal := {GoalsWithProductSummary.ProductGoal} ;

When I check the formula I am getting the error messaage "They keyword
then is missing"

Any help is always greatly appreciated.

Flanman

Thanks for the help. I was missing the () brackets on my month and year functions. Duhh.