Would anyone know if it's possible to concatenate ...
# generalu
7px
02/11/2022, 6:57 AMWould anyone know if it's possible to concatenate a Date field and a Time field into a Date/Time field via a workflow "Set Field Value" Action? If not, how do I go about converting both fields into strings? TO_CHAR doesn't seem to be working unless I'm following an incorrect format.
k
KevinJ of Kansas
02/11/2022, 10:01 AMThis is not possible with a workflow without some major hoop jumping
u
7px
02/11/2022, 10:03 AMWould you mind elaborating? I'm at a loss and quite close to just relegating free-form text fields for those specific fields.
k
KevinJ of Kansas
02/11/2022, 10:03 AMWhen are you trying to set it?
KevinJ of Kansas
02/11/2022, 10:04 AMis it a before user submit? after field edit? after record submit?
u
7px
02/11/2022, 10:04 AMIdeally after both fields are filled, so after field edit.
k
KevinJ of Kansas
02/11/2022, 10:04 AMIf it's in a client context which is after field edit- you have to do some kind of javascript math to make it work.
KevinJ of Kansas
02/11/2022, 10:05 AMI don't know what the formula would look like, but it'd be ugly partial suitescript
KevinJ of Kansas
02/11/2022, 10:05 AMand at that point - I'm just having my developer write a client script that's way more readable/straight forward anyways
👍 1
u
7px
02/11/2022, 10:05 AMAh, I see. So I suppose it's better I write a clientscript then. Thanks for the input.
k
KevinJ of Kansas
02/11/2022, 10:07 AMYeah, and you probably also need a user event script for when it is set via CSV upload/other methods as well
KevinJ of Kansas
02/11/2022, 10:07 AMand the formula for doing it in a workflow for those other contexts can be oracle sql at that point - but it'd be messy. And you already have most of the logic figured out in your client script - so may as well just turn it into a user event script with a few edits to cover those use cases as well