Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i am using the below expression in script and it is throwing error as invalid expression.
Date(Floor(MonthEnd(Max(Events.CLOSED_TIMESTAMP))), 'M/D/YYYY') as MonthYear
please help me out.
Hi
my code is as below:
Left Join(Recon)
Load *
Date(Floor(MonthEnd(Max(Events.CLOSED_TIMESTAMP))), 'M/D/YYYY') as MonthYear
resident Events;
Missing , after Load *
Hi,
After keeping comma as well, it was giving the same expression.
Could you comment out the line below load * (remove , ) as the next statement should be from/resident and try again ; so that we check if the line post load * is causing the issue