Thank you pradeep!!
I haven't had the time to check back with the Community. I was able to implemented the following script which is very similar to your solution. Hopefully, you can make use of this scripting at some point.
Load Min(Date) as MinDate, Max(Today()) as MaxDate resident StoreData;
Let vMinDate = Peek('MinDate',-1,'MinMaxDate') - 1;
Let vMaxDate = Peek('MaxDate',-1,'MinMaxDate') ;
Drop Table MinMaxDate;
'457' As Store,
0 As [Net Sales];
Load Date(recno()+$(vMinDate)) as Date Autogenerate vMaxDate - vMinDate;