LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only

  • 1.  combining data from multiple columns

    Employee
    Posted 07-13-2015 10:30

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    My data set contains a field for the day/month (as 1/10) and a field for the year (as 2014). I need to put this together in one field and output it as a date type with a YYYY-MM-DD format. I can split the day/month field apart and output it as an integer or as a string, but I don't know how to combine data across columns unless it is a mathematical operation. Thanks for the help.


  • 2.  RE: combining data from multiple columns

    Employee
    Posted 07-13-2015 11:24

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: ryeh

    Hi, Rebecca. You're basically there. You can use the 'date' function to stitch it all together! See the attached.
    Attachments:
    createDate.brg


  • 3.  RE: combining data from multiple columns

    Employee
    Posted 07-13-2015 13:00

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: rebecca_robare

    Thanks - that's great!