### Title

calculation fields

### Post

Hello all:

I am just starting work on a couple of calculation fields. I am really new at this

.Attached is my layout. Here is a description of the calculations, one is fairly simple, the second one is a mind bender for me, anyway...

1: The **Lead time **field, which will be the **PartDueDate** minus the **DateSubmitted**

2: The **PartStatus **field which has one of four results, each with a different colour...

- If
**DateCompleted**is blank and**DueDate**is not passed then**PartStatus**will be**InProcess** - If
**DateCompleted**is blank and**DueDate**is passed then**PartStatus**will be**OverDue** - If
**DateCompleted**has a date that is**on or before DueDate**then**PartStatus**will be**Complete** - If
**DateCompleted**has a date that is**after DueDate**then**PartStatus**will be**CompletedLate**

Any help as I make my way through this will be greatly appreciated as always...

Storywizard

PartDue and DateDue should be fields of type date.

If you are trying to enter a date directly into a calculation expression, you have to use a format that fielmaker recognizes as a date and not as a division problem.

In a calculation, 6/21/2010 means 6 divided by 21 divided by 2010.

Date ( 6 ; 21 ; 2010 ) means June 21, 2010.

Thus 6/21/2010 - 5/31/2010 will not give you the difference between the dates in days, but Date2Field - Date1Field will.