Concatenate Date and Time properties into a DateTime property
I would like to concatenate Date and Time properties into a DateTime property taking into account the requestor timezone and using an existing data transform, function or activity that could be reused everywhere in the application.
Is there an function, data transform or other generic element that could fulfill such basic conversion with input parameters Date, TimeOfDay, Hours, Minutes, ... and output DateTime?
Examples:
1) I have a Date property ("31/12/2019") and TimeOfDay property ("13:10:00") filled-in by a user in the timezone Europe/Brussels (GMT + 1) => I want to save the GMT value in a DateTime property ("31122019T12100000.000 GMT")
2) I have a Date property ("31/12/2019"), hours ("13") and minutes ("10") filled-in by a user in the timezone Europe/Brussels (GMT + 1) => I want to save the GMT value in a DateTime property ("31122019T12100000.000 GMT")
ING Belgium SA NV
BE
As you got no answer for the last two months, I think it's not that OOTB-solvable. Even when it seems a basic need. Did you find a solution? Could you share it as I'm currently facing the same problem. Thnx!
Updated: 4 Mar 2021 19:12 EST
Prime Therapeutics Inc
US
We had a similar requirement. Implemented using the below logic
Concatenate date and time values to form datetime:
Section Configurations:
ApprovalPubTime- is a time control of text data type Eg: 10:12 PM or 2:23 PM
ApprovalPubDate- is a Date control of date /datetime data type
Four Steps in Data Transform.
Step 1(Parameters should be of int type)
Param.Hrs== @toInt(@substring(.ApprovalPubTime,0,@String.indexOf(.ApprovalPubTime,":")))
Step2:
Param.HrsInt== @if(@String.endsWith(.ApprovalPubTime,"PM"),Param.Hrs+12,Param.Hrs)
Step3: Param.Mts== @String.toInt(@substring(.ApprovalPubTime,@String.indexOf(.ApprovalPubTime,":")+1,@String.indexOf(.ApprovalPubTime,":")+3))
Step4: .ConcatenatedProperty==@pxGetSpecifiedTimeOnDate(.ApprovalPubDate,Param.HrsInt,Param.Mts,0,"")