Discussion2Replies4705Views PraveenMohan Member since 2015 37 posts Allianz SE Posted: 5 years agoLast activity: 5 years ago 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 agoAnilkumarv29 Tcs replied to PraveenMohanWrite a When Check like @differenceBetweenDates(trans_date,@CurrentDateTime(),false,Default)>30 Posted: 5 years agoRaviP@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.