Setting Date Range for Dataset Update
I have an input dataset which are set to refresh every day using the replace method, and then runs through a recursive dataflow which drives an output dataset that has the most recent data.
I remembered in the past (12 months ago), in the DateFrom and DateTo fields for the data connector settings, instead of adding the actual date format into these fields, I was able to just enter say "-20" in the DateFrom field and it would automatically set to update the dataset with the last 20 days of data.
I only just realised now that this is no longer possible? When I enter a value other than a date format value in either the Datefrom and Dateto field, it will default to only bring back data from yesterday. Is there any way to get the same setup feature again?
The reason why I needed to constantly bring back last few days is because our input dataset values for certain fields changes over time, so I want to get the freshest set of data of the last 20 days every day to run it through recursive dataflow.