Question

5
Replies
4031
Views
 M Soren (SORENTARA)
Cognizant Technology Solutions

Cognizant Technology Solutions
IN
SORENTARA Member since 2014 28 posts
Cognizant Technology Solutions
Posted: April 17, 2018
Last activity: April 20, 2018
Posted: 17 Apr 2018 15:41 EDT
Last activity: 20 Apr 2018 10:16 EDT
Closed
Solved

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
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.

Accepted Solution

Posted: 3 years ago
Posted: 17 Apr 2018 17:00 EDT
Akshay Sawai (AKSHAY)
Cognizant Technology Solutions
Lead System Architect
Cognizant Technology Solutions
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.
Posted: 3 years ago
Posted: 17 Apr 2018 21:54 EDT
Vikash Ranjan Karn (Vikash Karn)
PEGA
Senior Technical Solutions Engineer
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://pdn.pega.com/community/pega-product-support/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://pdn.pega.com/community/product-support/question/date-difference-calculation


https://pdn.pega.com/community/product-support/question/how-compare-date-using-expression-builder


https://pdn.pega.com/community/product-support/question/compare-2-dates-validation-rule


https://pdn.pega.com/community/product-support/question/how-calculate-difference-between-two-dates-using-function

Show More

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://pdn.pega.com/community/pega-product-support/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://pdn.pega.com/community/product-support/question/date-difference-calculation


https://pdn.pega.com/community/product-support/question/how-compare-date-using-expression-builder


https://pdn.pega.com/community/product-support/question/compare-2-dates-validation-rule


https://pdn.pega.com/community/product-support/question/how-calculate-difference-between-two-dates-using-function


https://pdn.pega.com/community/product-support/question/we-need-calculate-difference-between-two-dates-get-output-%E2%80%9810


 


Regards,


Vikash


 



Show Less
Posted: 3 years ago
Posted: 20 Apr 2018 10:16 EDT
Premalatha Nagaraj (PremalathaN7222)
Cognizant Technology Solutions India Pvt Ltd

Cognizant Technology Solutions India Pvt Ltd
IN

This comment/reply has been branched into a new post