10 Replies Latest reply: Nov 26, 2012 5:12 AM by Grace Rashmi RSS

    How to load the Min date




      I have a table :


      Date | Call No | status


      i want to load the min(date) of a perticular call no where status is 79 or 13...


      Can any one help me to write the code for this


      i tried this but it is not working



      min(Date) as MDate,



      FROM [E:\Call Flow.xlsx] (ooxml, embedded labels, table is Day1) where status=79 or status=13;