Append Daily Data load - including missing dates

[#1]

LoadedDataLog.qvd

20160901

20160902

20160907

Source.qvd

which has all the data for dates that are in "LoadedDataLog.qvd"

vDataLoadStartDate = '20160901'

vDataLoadStopDate = today()-1   (day before current date)

What i want to create is mechanism where data will be loaded for missing date in log file ONE DAY AT A TIME up to vDataLoadStopDate.

so in above case:

Today()=20160910

Today()-1= 20160909

Missing dates are 20160903, 20160904,20160905,20160906,20160908,20160909

for u=one missing day at a time up till stop date

• load data for each missing date
• append to existing source.qvd
• Append date to "LoadedDataLog.qvd"

next u;

can you please help with coding above scenerio. Thanks