AnsweredAssumed Answered

Incorrect Formula?

Question asked by Jason_Farnsworth on Jul 13, 2012
Latest reply on Jul 13, 2012 by Jason_Farnsworth

I seem to not be getting the result I was wanting with this formula,

 

Let ([

DataDate = GetAsDate ( Data_Packages_Sent ) ;

IrrDate = GetAsDate ( Job_Interrupted )

] ;

Case (

IsValidExpression ( 1 * DataDate ) ; 1 * DataDate + 14 + not Int ( Mod ( 1 * DataDate + 687 ; 365 * 4 + 1 ) / 365 );

IsValidExpression ( 1 * IrrDate ) ; 1 * IrrDate + 14 + not Int ( Mod ( 1 * IrrDate + 687 ; 365 * 4 + 1 ) / 365 ) ; ""))

 

What I would like is...

 

Only one of DataDate or IrrDate is possible to have a date.

 

Which ever one hase one add 14 days to that date and display it.

 

If neither have any date do nothing

 

The solution works while only using one test of the case, but while adding the second test it work the first case and if the second case is needed it displays 1/14/0001

 

Thanks

 

Jason

Outcomes