I am trying to get all the dates using the 'date' field with the use of below code. Though the below code looks correct only it is not returning as expected.
If the min(ImplStart)=01/01/2011 and max(ImplEnd)=15/01/2011. When I select the date field in the list box it is should give all the dates i,e 01/01/2011,02/01/2011,.. and 15/01/2011. But the below codes returns only those date which are available in the ImplStart and ImplEnd.
Load *, Week(date) as Week, Year(date) as Year, WeekName(date) as WeekName, MonthName(date) as MonthName, WeekDay(date) as WeekDay ;
LOAD DISTINCT DATE(ImplStart+IterNo()-1) AS date RESIDENT Change_Calendar WHILE ImplStart+IterNo()-1<=ImplEnd;