Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
date($(varMinDate) + rowno()-1) As TempDate
$(varMaxDate)–$(varMinDate)+1;
MasterCalendar:
TempDate As OrderDate,
Week(TempDate) As Week,
Year(TempDate) As Year,
Month(TempDate) As Month
resident TempCalendar;
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.