1.        In the example below I show all the receipts against a purchase order. The 'Days' column calculates the days between the POdate and the Receipt Date. If the order line has not been received then the days should         calculate from the POdate to today's date. 

       

         


2.        It would have been a normal DateDiff if there were not fields that would have been 'null'. That is why we have put in a calc for =IsNull


       



 

Created with the Personal Edition of HelpNDoc: Enhance Your Documentation with HelpNDoc's Advanced Project Analyzer