Forum Discussion

vrice's avatar
vrice
Cloud Apps
03-21-2023

Days Since [Days in Date] Issue - Unexpected token

Hi,  In the past this formula worked for me to count the number of days since a date: DDiff(NOW([Days in date]),[Days in date]) but now I am seeing this error* Function Syntax Error: Unexpected...
Code-first Analytics
Silutions's avatar
Silutions
ETL
03-28-2023

With the new Analytical Engine you don't use the date variable with NOW.  Your ex.  DDiff(NOW(),[Days in date]) except you have to wrap the DDiff in an aggregation.  Ex. avg(DDiff(startTime, NOW()))

Hope this helps, Jim