Date Ranges

[nelliott]

I am trying to get a field to show a period number depending on what the date is - have tried a script which starts:

If (Date to Text (Period Start Date) < Date to Text (Today) < Date to Text (Period Start Date + (7*Period 1))

Insert "Period 1"

Where Period Start Date is the start of period 1

Period 1 is a field holding the number of weeks in that period

This is then repeated and amended accordingly for the further 11 periods

Unfortunately I cannot get this to work - Any ideas?

Cheers

Nick

[IdealData]

Try this..

Case(

Status(CurrentDate) < Period2StartDate; "Period 1";

Status(CurrentDate) < Period3StartDate; "Period 2";

Status(CurrentDate) < Period4StartDate; "Period 3";

..

..

Status(CurrentDate) >= Period11StartDate; "Period 12";

"INVALID")