DCVAN Posted November 13, 2001 Posted November 13, 2001 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.
LiveOak Posted November 13, 2001 Posted November 13, 2001 Labor Cost = Case(Date < Date(11,1,2001), TotalLaborHours * 50, TotalLaborHours * 55) -bd [ November 13, 2001: Message edited by: LiveOak ]
DCVAN Posted November 14, 2001 Author Posted November 14, 2001 That does the job perfectly, I am beginning to think that OakMan rules, thank you!
Recommended Posts
This topic is 8410 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now