5 Replies Latest reply: Jan 19, 2018 8:33 AM by Siddharth Sheshadri RSS

    Join using a date

    Julien Le Berre

      Hello

       

      I'm trying to join 2 tables using a date converted in month:

       

      Load

          MonthStart(date(cutomer_date)) as month,

          customer_id,

           ...

       

      Left join

       

      Load

           MonthStart(date(date#(call_date,'YYYYMM'))) as month,

           customer_id,

           ...

       

      Format:

      customer date = DD/MM/YYYY

      call_date= YYYYMM

       

      MonthStart() function gives the expected result and the "month" field value looks like 01/MM/YYYY, but the Join doesn't work.

       

      Any idea?

       

      Thanks!