master calendar error new?

Mon, 14 Jul 2014 16:59:08 GMT

Field not found - <–>

TempCalendar:

Load

date( + rowno()-1) As TempDate

Autogenerate 1

While

–+1

script i have like:

set varMinDate='01/01/2014';

let varMinDate=date(today);

TempCalendar:

Load

date($(varMinDate) + rowno()-1) As TempDate

Autogenerate 1

While

$(varMaxDate)–$(varMinDate)+1;

MasterCalendar:

Load

TempDate As OrderDate,

Week(TempDate) As Week,

Year(TempDate) As Year,

Month(TempDate) As Month

resident TempCalendar;

Re: master calendar error new?

Mon, 14 Jul 2014 17:06:48 GMT

Hi,

When you set your variable varMinDate use today function but you miss tip "()" after today, the correct sentence is:

LET varMinDate = Date(today(),'DD/MM/YYYY'); // or specify time format that you need.

If you just tip today without "()" you get "-" (incorrect value).

Best regards.