Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Folks,
I am trying load master calender and facing error while load below code:
LOAD date( floor($(varMaxDate) ) - recno() + 1) as Date
AUTOGENERATE NoOfDays;
Error in expression:
Floor takes 1-3 parameters
LOAD date( floor() - recno() + 1) as Date
AUTOGENERATE NoOfDays
varMaxDate doesn't contain a value.
Your initialization is wrong. Use a temporary table to aggregate, then use PEEK() to extract the value and save it to a variable.
And How initialized variables is :
Let varMaxDate = max(daystart(DateReceived));
Let varMinDate = min(daystart([Inbox.Received on]));
varMaxDate doesn't contain a value.
Your initialization is wrong. Use a temporary table to aggregate, then use PEEK() to extract the value and save it to a variable.
Let me check untill that
You are true,
Let varMaxDate = max(daystart(DateReceived)); is not getting any dat into variable.