1 Reply Latest reply on Aug 10, 2016 4:30 AM by John Sobczak

    Concat two datetime dimensions

    Romain Hapi

      I have two date dimensions that are pulled from the db, both are datetime format, and I want to concat both to use the date from the first one and the time from the second. Any help?

        • 1. Re: Concat two datetime dimensions
          John Sobczak

          You should be able to do this with DATEPART and MAKEDATETIME something like below although you might have to play to see exactly what syntax is required for the calc such as  # etc.

           

          MAKEDATETIME(DATEPART('month', [date1]) + DATEPART('day',[date1]) + DATEPART('year',[date1]),   DATEPART('hour', [date2]) + ...

          1 of 1 people found this helpful