### Title

Calculation Problem

### Post

Depening on the date entered into "FIELD A" I would addtional text entered into 'FIELD B".

Example FIELD A = 2/21/2009 therefore FIELD B = 09 QTR 1

Here is my calculation for FIELD B that does not seem to be working:

If(FIELD A>12/31/2007 and FIELD A<04/01/2008;"08 QTR 1";

If(FIELD A>03/31/2008 and FIELD A<07/01/2008;"08 QTR 2";

If(FIELD A>06/30/2008 and FIELD A<10/01/2008;"08 QTR 3";

If(FIELD A>09/30/2008 and FIELD A<01/01/2009;"08 QTR 4";

If(FIELD A>12/31/2008 and FIELD A<04/01/2009;"09 QTR 1";

If(FIELD A>03/31/2009 and FIELD A<07/01/2009;"09 QTR 2";

If(FIELD A>06/30/2009 and FIELD A<10/01/2009;"09 QTR 3";

If(FIELD A>09/30/2009 and FIELD A<01/01/2010;"09 QTR 4";""))))))))

Pasting a field definition from one of my own files:

Choose(Int((Month(Date)-1)/3); "First "; "Second "; "Third ";"Fourth " ) & "Quarter, " & Year(Date)

The text returned is different, but you should be able to edit that part to get what you want.

PS. Your calc should work if you enclosed the literal dates in GetasDate() functions.