6 Replies Latest reply: Mar 1, 2018 5:19 PM by Krishna Nagulapally RSS

    Calculate the the first 21 days of cash receipt to compare by month

    Ugur Arslan

      Hi,

       

      I have a table with a date dimension which shows me the cash receipt date. To compare the first 21 days of cash receipt each month I need to build a date expression.

       

      example date format is

       

      CashDate:

       

      2/18/2017

      2/28/2017

      2/22/2017

      2/1/2017

      2/5/2017

       

      expression:

      =Day(Date([Cash App Date]))

      18

      28

      22

      1

      5

       

      now I want to see only the days <21

      so the result should be

      18

      1

      5

       

      Which expression do I need to use?

       

      Thanks a lot.