3 Replies Latest reply: Jun 1, 2017 2:22 PM by Abhay Sudhakaran RSS

    extract day from date field not working

    Abhay Sudhakaran

      ETLCal:

      Load *,

      Day(New_Date) as tmp_day

      Day([To Date]) as tmp_day2,

      ;

      LOAD [Loading Date],

           [From Date],

           [To Date],

           Date#([To Date]) as New_Date,

           Status

      FROM $(vCalendarPath)

      (txt, utf8, embedded labels, delimiter is ',', msq)

      //  where match(Day([To Date]),28,29,30,31)

      ;

       

       

      I am unable to extract day from the date field. I tried typecasting the field and converting it to a set date format but no luck.

      Would be really helpful if someone can look at this issue.

       

      I have attached the calendar csv I am using to pull the dates from.