2 Replies Latest reply on Mar 15, 2019 12:42 AM by Bruce Donald

    Identifying Document Dates within a Date Range by Employee

    Bruce Donald

      Hi Community,

       

      I am hoping for some assistance with the following.

       

      I am attempting to establish whether any invoice dates (processed by each employee, 'Employee'), invoice date expressed as 'Doc Date' fall within the date range between 'From Date' and 'To Date'.

       

      I.e. does invoice X with invoice date 7-7-17 processed by employee Y fall within date range 'From Date' to 'To Date'.

       

      I have attached a screenshot of some example data.

       

      I would appreciate any feedback.

       

      Thanks.