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