Question
Pegasystems Inc.
JP
Last activity: 1 Mar 2016 9:28 EST
7.1.9 @DateTime.TimeDifference returns invalid date time string that can not be assigned to a DateTime property
I was trying to set a DateTime type property using declare expression like below, however the expression fails because @DateTime.TimeDifference function returns invalid date time string.
.ToDate [email protected](.FromDate,7,0,0,0)
FAIL
Step Status Info
** Invalid datetime format/Invalid datetime "Fri 2016/03/04 22:31:00 GMT+00:00"
Is this a known issue? or is it designed to return a date time string that can not be directly assigned to a DateTime type property?
Pegasystems Inc.
US
Can you use DateTimeDifference function instead? TimeDifference is not being used at all OOTB, but DateTimeDifference is used in a declarative expression OOTB, just use references action.
Virtusa
IN
Hi Chunzhi,
The return type of the TimeDeferance function will be pf String which will be in the format which is mentioned by you.
If this is your requirement to add a specific number of days, hours, mins, seconds to calculate a new date, then you can use the function "addToDate" in date time library.
Thanks.
Pegasystems Inc.
JP
I guess DateTime type in Pega expects a date time string in GMT with ISO format.
Then why not any function returns a date time string simply returns a Pega DateTime compatible string and leave the formatting issue to the caller of that function? What is the benifit of returning a string that doesn't compatible with DateTime type?
Pegasystems Inc.
US
This function has been documented to return that format in it's help and has been around since Pega 5.4 and probably earlier.
At this point I would think the reason is just for backwards compatibility.