DateVar Problem

[rb74]

Hi everyone,

I am using a formula to calculate Age of an individual based on a date of birth and another date. When I am declaring the variables, I am getting the error: A Date is required here. The cursor is placed before the field of the individual's date of birth. Here is my declaration:

WhileReadingRecords;
DateVar DOB := {Members.AnnuitantDOB};
DateVar Retire := {Orders.RetirementDate};

The field AnnuitantDOB is a date/time field in Access along with the Retirement Date field. Why am I receiving this error message?

Thanks for help in advance,

Rob [Vader2]

 

[rb74]

Hi,

I figured it out. I declared each variable DateTimeVar.



Thanks,

Rob [Vader2]