Using date as a condition

Chong-ho (Alex) Yu, Ph.D., MCSE, CNE, CCNA


I am setting up a conference registration DB. I want to use a calculation field named "fee" to return the value of the conference fee based upon the registration date. Before December 31, 2001, the conference fee is $100. Afterwards, the fee will increase to $150. The following synatx appears to be logical but it doesn't work.

if (date <= 12/31/2001, 100, 150)


if (date_value <= 730850, 100, 150)


FMP Tips Contents

Other computer tips

Search Engine

Credit/Copyright ©

Simplified Navigation

Table of Contents

Contact Me