Question
Ciberspring International (India) LLP
IN
Last activity: 23 Apr 2020 23:19 EDT
Datedifference
Hi All,
I have two dates and I need difference in months. Is there any function which will helep this I already used differenceBetweenDays function but its giving in days. @(Pega-RULES:BusinessCalendar).differenceBetweenDays(.YearOfPurchase, @getCurrentDateStamp(),false,"")
Example: Selected date = 01/02/2017 Current Date = 21/04/2020
Required Difference in Months.
***Edited by Moderator Marissa to update Pega Academy to General; Platform Capability tags****
IN
Hi Raghunathrao,
You can do using following way
@DateTime.FormatDateTime(@differenceBetweenDays("20200716T000000.000 GMT",@DateTime.CurrentDateTime(),false,""),"M","","")
Hope this helps
Thanks
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
We can use DateTimeDifference to get the difference in months, but the format should be date-time.
Please find the sample usage for the function below.
@DateTime.DateTimeDifference("20200725T000000.000 GMT","20200121T000000.000 GMT", M)
Pegasystems Inc.
IN
Can you try both parameterized and hard coded values.
@(Pega-RULES:DateTime).DateTimeDifference(.OldDatetime, .CurrentDateTime, "D") @(Pega-RULES:DateTime).DateTimeDifference("20171120T201834.985 GMT", "20171124T201834.985 GMT", "D")
Hope this might help