2 Replies Latest reply: Apr 30, 2018 12:29 PM by Ashley Kuttler RSS

    Filtering Dates in Load Script

    Ashley Kuttler

      Hello,

       

      What is the syntax I would use to filter for dates in my data Load?

       

      For example:

       

      PL_ENC:

      LOAD

          Date(Floor("SERVICE DATE")) as "Date",

          PATIENTID,

          CPT,

          LocationName,

          RenderingPhysician,

          ITEMTYPE,

          Units as UNITS,

          PracticeName,

          ENCID,

          CPT_CATEGORY

      FROM [lib://ENTERPRISE/PATIENT LEDGER.xlsx]

      (ooxml, embedded labels, table is [Charge Pivot])

      WHERE "SERVICE DATE" BETWEEN '01-01-2017 and  '12-31-2017'


      Thanks in advance.