Are SQL data source date functions performed on Klipfolio's servers?

Carlos Kynäslahti

August 22, 2017 13:24

None

Hi,

I have an SQL data source which connects to a Microsoft SQL server. The script uses the function GETDATE() as a part of the query to limit the results to the current day. I'm not entirely certain how Klipfolio handles SQL scripts. Is the GETDATE() function performed somewhere on Klipfolio's end and then queried or is it sent as it is to my SQL servers? If it's performed somewhere on Klipfolio's end, which timezone does it use so I can create an offset? The reason I'm asking is because a user reported seeing data for the previous day at around 2AM and the only explanation I can come up with is this. I tried using "debug_info" on the data source but couldn't find anything that way.

Best regards,

Carlos Kynäslahti

Carlos Kynäslahti August 23, 2017 13:20

I posted a support ticket this and learnt that SQL data source queries also support Klipfolio's excellent date scripts: https://support.klipfolio.com/hc/en-us/articles/216181877-Use-date-range-parameters-to-modify-data-retrieval-period

This means I don't have to use SQL date functions for my queries.

PS. Remember to enclose date scripts with single quotation marks: ' ' !

How can we help?

Are SQL data source date functions performed on Klipfolio's servers?

1 comment