6 Replies Latest reply: Sep 22, 2016 2:11 AM by Madeleine Josefsson RSS

    Question regarding a date filter

    Madeleine Josefsson

      Hello,

      I have the following section in my script:

       

      LOAD

          TRNumber,

          CompCodeTRNumberKey,

          RegistrationDate,

          ReceiptComment,

          TransactionDate as InvoiceDate,

           year (TransactionDate) as InvoiceYear,

      month (TransactionDate) as InvoiceMonth,

          TransactionType,

          Account

      FROM [lib://Receipt.qvd]

      (qvd)WHERE match(Account, 3040, 3042, 4643, 4644, 4645, 4646, 4647, 4648, 4649)and [TransactionDate]>MakeDate(2010);

       

      Is there any way that I can make my date filter of Invoice Year and Invoice Month to be based on only account 3040 and 3042?

       

      Thanks!