4 Replies Latest reply on Jun 5, 2015 8:27 AM by craigd25760504

    Need to concatenate formatted date field and numeric field

    craigd25760504

      Hello,

      I have a date field and a 4-digit numeric field in my form. I want to concatenate these two fields into a new field in the following format: "yyyymmdd[4-digit numeric field]".

       

      E.g.

      Date: June 4, 2015

      Number: 1234

      Concatenated Field: 201506041234

       

      When I try to concatenate the date value, I get the string value entered instead of the actual date (e.g. "June 4").

       

      Thanks.