Q: Does ConnectR have the functionality to compare dates?

Comparing dates cannot be accomplished via the built-in functionality of ConnectR, however a VB script utilizing datediff can be used to accomplished the desired result:

  Dim result
  If datediff(“d”, Date1, Now) <0 Then
      Result = “Y”
  Else
      Result = “N”
  End If