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, 200619 yr by Guest

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.

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.

Thanks Raybaudi :yourock: