4 Replies Latest reply: Nov 12, 2012 6:13 AM by Stefan Wühl RSS

    Matching the date format of a field imported from csv

      Hi all,

       

      I am trying to match the format of 2 date fields 1 from a resident table and the second one from a csv file.

       

      The first date from the resident table is calculated using the date(date#(WeekEnd(now(),3,-2)))) as myDate

       

      Second date comes from the csv file with the following expression.

       

      LOAD date(date#(myDate)) as myDate from $(myPath)$(vSonPlan).csv (txt, delimiter is ',');

       

      When I try joinint the tables I based on the date the join doesn't work because the fields are not formated the same. I get 2 rows for the same date. 1 from the 1st table 2nd from the second.

       

      Could anyone help??

       

      Thanks