How to find date difference between datetime and date field

[rsp]

Is it possible to calculate the date different between datetime and date fields using below CustomFunction? @maretval

datediff({tc}.DateTime,{tc}.Date)

[maretval]

W3Schools.com

Good luck

[rsp]

Thank you, the below query returned correct number of days on the w3schools.

SELECT DATEDIFF(“2016-06-25 09:34:21”, “2016-06-01”);