AnsweredAssumed Answered

Set as DATE Type EXECUTVESQL

Question asked by JamesPeragine on Jul 12, 2017
Latest reply on Jul 13, 2017 by user19752

I'm using ExecuteSQL()  to Compare two dates in Join.  How can I pass the field type as DATE()

 

 

ExecuteSQL ( "SELECT Count (*) FROM \"KabbageSubmissions_Filter\" S JOIN Kabbage777 K ON S.\"_pkKabbageSubmissions\" = K.\"_fkKabbageSubmissions\" 

WHERE \"_pkSubmissions\" = K.\"_fkSubmissions\"

AND

 

S.\"Channel Add Date\" = K.\"ChannelAddDate\"

AND

S.\"Credit Consent Date\" = K.\"CreditConsentDate\" "

 

; "" ; "")

 

The results aren't correct and I think it's because SQL isn't seeing both fields as dates.

Outcomes