Discussion2Replies4860Views×Close popoverPraveen Mohan (PraveenMohan) Allianz SE Allianz SE IN View ProfileSend Message PraveenMohan Member since 2015 38 posts Allianz SE Posted: September 23, 2015Last activity: September 23, 2015Posted: 23 Sep 2015 5:14 EDTLast activity: 23 Sep 2015 10:57 EDT Closed Date comparisonI need to check 'trans_date'(a variable) is 30 days greater than today's date.How to do this?×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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 Discussion, please write a new Discussion. Posted: 5 years agoPosted: 23 Sep 2015 9:55 EDT×Close popoverAnilkumar vooradi (Anilkumarv29) Tcs Pega Developer Tcs IN View ProfileSend MessageAnilkumarv29 Tcs replied to PraveenMohanWrite a When Check like @differenceBetweenDates(trans_date,@CurrentDateTime(),false,Default)>30 Posted: 5 years agoPosted: 23 Sep 2015 10:57 EDT×Close popoverRavi Padwal (RaviP@incessant) NIIT Technologies Limited NIIT Technologies Limited AU View ProfileSend MessageRaviP@incessant NIIT Technologies Limited replied to PraveenMohanWhere do you want to use it? If you want to use it in activity, approach suggested by Anil will work. If you want to find out days difference in report, use SQL function pxDifferenceInDays.