Red Flag Calculation

[bob sherman]

Is there a calculation that can be used that will red flag a record when a date has been reached? I have start date and a due date. When the due date is reached I would like it to red flag automatically. Thanks for your ideas.

[Lee Smith]

Two Fields are required

One Called g_Flag, make it a Global Container (You will need to past your flag into it)

The other, call it Flag, is a calculation

Case(DueDate > Status(CurrentDate), g_Flag)

HTH

LEE

[LaRetta]

Hi,

Red flag just went off! You might consider changing > to <=.

LaRetta

[bob sherman]

Thank you for help, but I didn't actually want a "red flag." I was looking for a way to change a background color, or deliver some sort of message to red flag an overdue item. Thanks

[bob sherman]

Thank you Lee and LaRetta for your help. I was able to achieve a background color by using Paint.

Bob Sherman

[Lee Smith]

Hi Bob,

I'm not sure I understand your solution, when you say: [color:"blue"]you achieved this by using "Paint" . I would love to see a demo of this, as the method I mentioned [color:"blue"] (See Attachment) has been the one I've always used to achieve this, and I'm always looking for better or other ways of doing things.

HTH

Lee

Flag.fp5.zip

[bob sherman]

Hi Lee,

I never revisited my post last August regarding red flagging overdue dates and am sorry I just now found your question. Thank you for your download. I created the same fields that you did. The only difference is that I put the "Flag" (calculation field) next to the date rather than underneath. To create my color, I used my Paint program that comes with Accessories in my Windows operating system. I design in Windows. Your approach is simpler than mine. Thanks again.

Bob Sherman