Date Difference

Question

Question

Shubhendu Pattnaik · Feb 1, 2022

I am having a scenario where I need to check difference between current date and a past date should be less than 31 in Routing Rule. Can anybody help me how to code that?

Discussion (2)0

Log in or sign up to continue

Robert Cemper · Feb 1, 2022

#1 convert both dates to $HOROLOG format and substract it

# 2 use $system.SQL.Functions.DATEDIFF()

2 0

score 1 · Answer 1 · 2022-02-06T20:15:56-05:00

Here is the custom class for this...

You should add this in one of your custom class which Extends Ens.Rule.FunctionSet so that it is visible in Routing Rule.

ClassMethod DaysFromToday(pDate As %String) As %Integer
{
Set tNow = $H+0
Return $ZDATEH($EXTRACT(pDate,1,8),8) - tNow
}

I got this from Jeffrey Drumm.