Using AutoGenerate Function correctly

[Anonymous]

I want to create a table that will have one field that lists all dates between my oldest date and my most recent date (Field: Created At is the date field).  What I have below does not work. The last table I create (Tempcalendar) only shows one date instead of all dates between MinDate and MaxDate. Thanks.

GetDateRange:
Load
date(Min([Created At])) as MinDate,
date(Max([Created At])) as MaxDate
Resident MARKETO;

Let vMinDate=Peek('MinDate',0,'GetDateRange');
Let vMaxDate=Peek('MaxDate',0,'GetDateRange');

TempCalendar:
Load
DATE($(vMinDate) + RowNo() -1) as Tempdate
AutoGenerate $(vMaxDate)-$(vMinDate)+1;

[swuehl]

Seems to work if you use numeric values for your variables:

SET DateFormat='DD.MM.YYYY';

GetDateRange:

Load

Min([Created At]) as MinDate,

Max([Created At]) as MaxDate

INLINE [

Created At

01.01.2017

22.12.2016

];

Let vMinDate=Peek('MinDate',0,'GetDateRange');

Let vMaxDate=Peek('MaxDate',0,'GetDateRange');

TempCalendar:

Load

DATE($(vMinDate) + RowNo() -1) as Tempdate

AutoGenerate $(vMaxDate)-$(vMinDate)+1;