Q: Does ConnectR have the functionality to compare dates?
Revision as of 14:34, 19 January 2009 by Justin.Campbell (talk | contribs) (New page: Comparing dates cannot be accomplished via the built-in functionality of ConnectR, however a VB script utilizing [http://www.w3schools.com/Vbscript/func_datediff.asp datediff] can be used ...)
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