2 Replies Latest reply on Feb 22, 2018 11:41 AM by Tim Mullady

    Join into a calculated field

    Tim Mullady

      Hello,

       

      I have one data set with a 'hotel code' and 'date'.  I have one calculated field based on the [date] like the following.

       

      ---DATE BUCKET

       

      IF [Date] >= #10/01/2017# AND [Date] <= #12/22/2017#

      THEN '2017 Q4 1222'

      ELSEIF [Date] >= #12/23/2017# AND [Date] <= #01/06/2018#

      THEN '2017 Q4 0106'

       

      I'm then concatenating them together to create unique identifier

       

      [hotel code]+[DATE BUCKET]   example - XYXABC2017 Q4 0106

       

       

      Is there anyway that I can join a data set into the unique identifier?  The create join calculation... feature does don't have the calculated field available in the list.

       

      Or could I use [hotel code]+ IF STATEMENT for the DATE BUCKET

       

       

       

      Any information would be greatly appreciated.

       

      thanks,

       

      Tim