floor(Date) issue

[#1]

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

[#2]

And How initialized variables is :

Let varMaxDate = max(daystart(DateReceived));

Let varMinDate = min(daystart([Inbox.Received on]));

[luciancotea · Accepted solution]

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.

[#4]

Let me check untill that

[#5]

You are true,

Let varMaxDate = max(daystart(DateReceived)); is not getting any dat into variable.