I seem to not be getting the result I was wanting with this formula,
DataDate = GetAsDate ( Data_Packages_Sent ) ;
IrrDate = GetAsDate ( Job_Interrupted )
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