I want to create a unique ID field for each row of data based on the created_date and OBJECTID. For example, if a sample of data had a created_date on 4/28/17 and an OBJECTID of 1, than I would want the unique ID field to be 20170428-1.
I believe I first have to convert the created_date field to string, and then concatenate the date (string) field with OBJECTID. I am using ArcGIS Online's Expression Builder to do this.
In order to convert created_date to string, I have tried using the CAST function, but that does not work. I have also tried to use the EXTRACT function to extract the year, month, and day from the date in order to combine them, but I can only extract one portion of the date (ex: just the year).
Would the Convert Time Field tool be of use to me?