Hi
How could I use getdate() in sentences sql to Marketing cloud,?
I tried getdate() but this generated error
Thanks for your help
If we understood you correctly, you want use getdate() funtion in Skyvia Query Tool when quering data from your Salesforce Marketing Cloud instance. Correct?
Please try using this solution:
SELECT t.Name
FROM Account AS t
where t.CreatedDate < date('now')
Please notify us about the results.
Best regards,
Mariia
Hi
Thanks for your help and reply
The sentence date(´now) work in Skyvia Query Tool but at this moment, this is not work in Marketing cloud, the error generated " unknown the function date".
why do the sentence getdate() in Skyvia Query Tool not work?
this is not work in Marketing cloud, the error generated " unknown the function date".
Please specify where exactly you are trying to execute your SQL query?
The sentence date(´now) work in Skyvia Query Tool
why do the sentence getdate() in Skyvia Query Tool not work?
Skyvia Query Tool uses its own SQL syntax for query execution (it is based on SQLite) and, thus, you should use date() function instead of the getdate() one. Please refer to: https://skyvia.com/resources/docs/index.html?select.htm
