How to add year in a date and compare with current date
Hi,
I have requirement like i have to fetch the date of a transaction from DB table in which I have to add certain year(eg: 7 yrs.) in activity and then compare it with current date (eg: Currentdate>transaction+7yrs) and based on that comparision I have to update the status of that transaction..
ow to add year in a date and compare it with current date.
Regards,
SorenTara
Accepted Solution
LTI Mindtree
CA
You can use below functions to achieve your requirement.
param.FutureDate= @DateTime.addCalendar(@DateTime.CurrentDate("","EST"),7,0,0,0,0,0,0)
param.IsValidTransaction= @differenceBetweenDateTimes(@CurrentDateTime(),param.FutureDate,true,"")>0
I hope this will help.
Pegasystems Inc.
IN
Hi,
You can refer to the below link which explains how to add number of days to a date (in the same way you can either add years to the date or you can convert the year count to no of days and then add the same):
https://collaborate.pega.com/question/how-add-given-days-number-date-using-only-business-days
There are multiple ways to compare two dates, you can refer below links for the same:
https://collaborate.pega.com/question/date-difference-calculation
https://collaborate.pega.com/discussion/how-compare-date-using-expression-builder
https://collaborate.pega.com/discussion/compare-2-dates-validation-rule
https://collaborate.pega.com/question/how-calculate-difference-between-two-dates-using-function
Hi,
You can refer to the below link which explains how to add number of days to a date (in the same way you can either add years to the date or you can convert the year count to no of days and then add the same):
https://collaborate.pega.com/question/how-add-given-days-number-date-using-only-business-days
There are multiple ways to compare two dates, you can refer below links for the same:
https://collaborate.pega.com/question/date-difference-calculation
https://collaborate.pega.com/discussion/how-compare-date-using-expression-builder
https://collaborate.pega.com/discussion/compare-2-dates-validation-rule
https://collaborate.pega.com/question/how-calculate-difference-between-two-dates-using-function
Regards,
Vikash
