8 Replies Latest reply: Nov 5, 2014 3:26 AM by Amit Saini RSS

    Cal no. of days from today ???

    Amit Saini

      Folks ,

       

      I'm trying a simple logic for calculating no. of days , but some how it's not working .

      See below:

       

      LOAD Sales,

      ( Date(Today(),'MM-DD-YYYY') - Date(Sales,'MM-DD-YYYY'))  as NoOfDays

      FROM

      [C:\Users\asaini\Desktop\Time Stamp.xlsx]

      (ooxml, embedded labels, table is Sheet5);

       

      Kindly help here.

       

      Thanks,
      AS