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??