Date conversion when one is not known yet
I am trying to set up a calculation to find out balance due where I know the submit date for an invoice but don't always know the date yet for the invoice payment received date. If I set up submit date - payment date and the payment date isn't entered it enters useless information which clogs the layout. Is there a way to set up the calculation to only calculate if both dates are entered??
thanks for any help