2 Replies Latest reply on Feb 26, 2011 4:53 PM by raybaudi

    calculating number of days between 2 dates when 1 field date is empty

    BaruchFeldman

      Title

      calculating number of days between 2 dates when 1 field date is empty

      Post

      calculating th enumber of days between 2 dates is OK when the end date and start date are there. when both date fields are empty the calculation field is empty ( good for me) but when only 1 date field is empty the result is huge negative or positive result. How to avoid miss-calculation when start date or end date is missing (one date field is empty)?