Case

[Ricardo]

Hi All,

I have db which the view field is colour coded depending on the age of a job.

It works fine until the age of the job (days in production field) goes beyond 9 days old and less then 20 days old.

The filed is a calculation the result being a container.

the calc looks to a container field with 4 repetitions all containing different colour blocks and depending on the result displays the colour of the repetition.

here is the calc

Case(

Job Done = "1", GetRepetition(Container, 3),

Days in Production >= "3", GetRepetition(Container, 1),

Days in Production = "2", GetRepetition(Container, 4),

Days in Production < "2", GetRepetition(Container, 2),

"")

how can i fix it so that when it is over 10 days and still in 'Production' it gets rep 1 and so on. At the minute if the job is 10 days old it defaults to rep 2.

I have messed about setting the number of days in Production field with decimals etc etc but no joy.

the db is created in FM Pro 6

Thanks in advance,

ricardo.

[jasonwood]

Just a thought... is your "days old" field a text field or a number field? alphabetically, 10 is less than 2. You need a number field.

[Ricardo]

i've worked it out using the Int(number) function within the case function.

Thanks for you help.

ricardo.