If ( DayOfWeek ( appt date ) = 2 ; Appt Date - 3 ; appt Date - 1 )
Select Date as the calculation field's return type.
Dates are really number fields that store an integer counting the number days from 12/31/0000 to the date entered in the field so we can add or subtract numbers and the date returned will be a date increased or decreased by that number of days.
when i try it out it just gives me ? symbol...
is Appt date a field of type date when you check it in Manage | database | Fields?
IS the field wide enough to display the date with the date format specified for it? (Try clicking into the field while in browse. If this is the problem, you'll see the value when you click into the field.)
now it is. thnx its works!