1 Reply Latest reply: May 15, 2014 9:59 AM by Grant Perkins RSS

    concatinate two fields

    Oli _

      I try to concatinate 2 fields.

       

      One field is a date field and the other one a character field. How can I handle this ?

       

      Oli

        • concatinate two fields
          Grant Perkins

          Oli,

           

          I would guess that you will need to convert the date to a character field in the formula. I assume the character field is not also a date?  (But even if it is a date field cannot contain 2 dates!)

           

          In this case I think you will need the DtoC function (Date to Character)

           

          DToC(Date_Field)+Character_Field

           

          should do it.

           

          Or some variation on that idea to change the order or insert spaces or other fixed characters for example.

           

          HTH.

           

           

          Grant

           

           

          Edit: If you look at the included help there seems to be a small error in the example which refers to CtoD rather than DtoC.

           

          CtoD is the opposite conversion and would convert a character format date into a real date field.