I tried the date function as well, the script part looks like this:
SELECT "cm_parent_webpageid", "cm_parent_webpageidname",
"cm_referringdomain", "cm_trafficsourcename", "cm_viewdate"
When I put the cm_viedate (this is the date part) in this formula and reload I get a error saying: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'Date' is not a recognized built-in function name.
Why do I get this message?