Concatenating fields into a single date/time field

[George Tsemberlis]

Hi there,

For reasons that predate my involvement, there is a single select field that exists in our instance that consists of a bunch of times, eg "3:00 PM"

I'd like to  backfill via an A4J rule to combine these with an existing date field into a new single Date/Time Field but am having difficulty getting the values of both of these fields into something that Jira will accept as a valid entry for a date/time field.

Any advice? 

[Bill Sheboy]

Hi @George Tsemberlis 

Without seeing the specifics of your rule for context...

There are several ways to do this using date / time functions:

1. Parse the date and time values as text, merge them, and then convert with the toDate() function and the specific format.  I would try this way first.
2. Parse the time value into parts, and use the with[Attribute] functions to set the hour, minute, etc. for the date
3. Parse the date, and use with[Attribute] to combine to the time (i.e., this is the opposite of #2 above)

Kind regards,
Bill