Alert calculation

[Gilbert]

Hello,

I have a number field called [Days before alert] and a date field with the expiration date.

Days before alert = 5

Expiration date = 7/17/2006

Today: 7/15/2006

My alert calculation 1 should start a count down for 5 days up to the expiration date, then the alert calculation 2 should go on.

Please see the attachment

Thanks.

Alert_test.zip

Edited July 16, 2006 by Guest

[T-Square]

Try combining the two calcs into one, i.e. if the first test succeeds, then put up one text message ELSE use the second. BTW, usually I find it clearest to set up simple tests that are unambiguously true or false, and embed secondary tests within that first test. Far too often I string together two or three into one grand test only to find that the combination has a different result than I planned.

[Raybaudi]

Hi

try this lonely calc ( only one field)

Let(

days = Expiration date - Get ( CurrentDate );

Case(

IsEmpty ( Clear_Alert);

Case (

days > 0 and days ≤ days before alert ; "Alert: Task Expires in "& TextColor ( days ; RGB ( 0 ; 0 ; 255 ) ) &" days " & TextColor ( Expiration date ; RGB ( 0 ; 0 ; 255 ) );

days = 0 ; "Alert: Task Expires ToDay " & TextColor ( Expiration date ; RGB ( 0 ; 0 ; 255 ) );

days < 0; "Alert: Task Is over " & TextColor ( Abs ( days ) ; RGB ( 255 ; 0 ; 0 ) ) &" Days. " & TextColor ( Expiration date ; RGB ( 255 ; 0 ; 0 ) );

""

)

)

)

Remember to make the calc UNSTORED.

[Gilbert]

Thanks Raybaudi :yourock: