I have two separate fields - one a date and one a time - that I need to concatenate together into one long datetime field. Date field is a numeric field, currently in the YYYY-MM-DD format (2014-07-24 for example) and the time field is numeric in the HH:MM:SS format (9:23:00 or 11:35:00 for example - the leading 0 is not there for half of the time). I need to get these two separate fields into a format that looks like: 01NOV13:09:23:00 - the date has a length of 7, the time has a length of 8 and there is a colon between them. I tried formatting both fields, then concatenating, then formatting the concatenated field, and no such luck. Thanks!
... View more