Discussion
2
Replies
5125
Views
Allianz SE
IN
Posted: September 23, 2015
Last activity: September 23, 2015
Last activity: 23 Sep 2015 10:57 EDT
Closed
Date comparison
I need to check 'trans_date'(a variable) is 30 days greater than today's date.How to do this?
Moderation Team has archived post,
Posted: 6 years ago
Tcs
IN
Write a When Check like
@differenceBetweenDates(trans_date,@CurrentDateTime(),false,Default)>30
Posted: 6 years ago
NIIT Technologies Limited
AU
Where 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.