hi there,
I need to produce an sql expression that will give me the number of contacts between two dates. the back-end db is SQL server, but the SQL expression fails with an error that reads
'conversion failed when converting date and or tie from character string'
the sql syntax i am using is event_date_time between '2017,01,01' and '2017,01,01'
thanks in advance
I need to produce an sql expression that will give me the number of contacts between two dates. the back-end db is SQL server, but the SQL expression fails with an error that reads
'conversion failed when converting date and or tie from character string'
the sql syntax i am using is event_date_time between '2017,01,01' and '2017,01,01'
thanks in advance