DATEDIFF(dd, Audits.dstart, getdate()) AS no_of_days -- or CAST(getdate()-Audits.dstart AS int) AS no_of_days>I have a remote view with the following field expression. I am trying to calculate the number of days between the audit start and the current date. This is not returning the number of days however it's returning a datetime value. How can I perform this calculation and have the results listed as a field in the select cursor?