I have a calculation that is date specific

I need to take a field, multiply it by a number if applies to Nov 1 or later in a date field, and I need to take the same field and multiply it by a different number if another if the date is prior to Nov 1.

What we are attempting is to alter a labour charge if it occurs after November.

For example:

Labour Cost = "total labour hours" * $50 if the "date created" is less than 11,01,01 or else the "total labour hours" * $55

Any help is definitely appreciated as I am obviously not a programmer.

Labor Cost =

Case(Date < Date(11,1,2001), TotalLaborHours * 50, TotalLaborHours * 55)

-bd

[ November 13, 2001: Message edited by: LiveOak ]

That does the job perfectly, I am beginning to think that OakMan rules, thank you!