2 Replies Latest reply on Jul 4, 2016 8:35 AM by Lucie Brett

    Relationships: blending data sources on dates

    Lucie Brett

      Hello forum friends


      I am trying to blend two data sources; actuals and targets which are date fields.


      The target data has the date of 1st of the month but the actuals are different days throughout the month (of which I want a total). I have added a calculated field and have tried to force every actual date to be the 1st so that I could create a relationship between the two but the below didn't work:


      MAKEDATE(INT([Date First DIP Accepted]),INT([Date First DIP Accepted]), 1)


      Does anyone have any advice on how I could make this work please?


      Thanks in advance