Home Page Link
  Skip Navigation Links
Log in to create posts To create new posts or to reply to existing ones, you must be registered and logged in!
  
View: 
Post
Started: 1/8/2010 9:21 AM
Picture Placeholder: Chester Thomas
Chester Thomas
Calculation based on day of the week
Good day everyone,
 
I have a calculation field for an overtime claim form I designed. Everything works well but the only thing is I need to add up hours based on day of the week ie if it is a sunday then it should be added in a box called ratex2 and if it is any other day it is a box called ratex1.5
 
I want to use rules as far as possible. Any help will be appreciated.
 
Regards,
 
Chester
Posted: 2/22/2010 3:49 PM
Picture Placeholder: Jacques Murray
Jacques Murray
Hi Chester,
 
How did you create your form? InfoPath, customized page or web part?
Posted: 3/8/2010 3:10 PM
Picture Placeholder: Chester Thomas
Chester Thomas
its in infopath. I got it right thanks. I used rules. I converted all my days of the week to numbers and Sunday is 0.
Posted: 3/8/2010 3:54 PM
Picture Placeholder: Jacques Murray
Jacques Murray
Good work. Glad you came right.
Feedback