Question
Citi
US
Last activity: 30 Aug 2024 13:15 EDT
Integer to Date
Hello,
we are receiving date properties as integer types (YYYYMMDD). August 30, 2024 = 20240830
I am having trouble converting the int to a date type so we can do calculations with date/ dateTime types (difference between dates, etc). I have tried using @dateValue and @date but since these return bigDecimals they cause errors in the calculations.
Has anyone used a different function?
Thank you!
Accepted Solution
Updated: 30 Aug 2024 15:18 EDT
WTW
PE
@DaniV17021618 I think you can use the following functions @DateTimeDifference(@addToDate(Param.PaymentDate,0,0,0,0),@CurrentDateTime(),"D")
Maantic Inc
IN
Pega ideally stores date-only properties as integers. So an integer property can be used for calculations against date-only fields.
Citi
US
Thank you for your reply! Does this mean calculations between integers and DateTimes are not possible?
I am trying to find how many days ago a payment was made. I'm not sure why I would get two different results or what they represent.
Ex:
@today() - .paymentDate = 19965 or -20220864
where .paymentDate = 20240829
Accepted Solution
Updated: 30 Aug 2024 15:18 EDT
WTW
PE
@DaniV17021618 I think you can use the following functions @DateTimeDifference(@addToDate(Param.PaymentDate,0,0,0,0),@CurrentDateTime(),"D")