This workflow demonstrates using flow variables in the date and time nodes. Here the use case is to filter the last full week of data. Hence if you execute the workflow on Wednesday you still only want to get the data until the last Saturday. We achieve this by first finding the last Sunday. This will be the enddate in our filter node. Afterwards we use the information as a flow variable in the Date&Time-based Row Filter node. In addition we set the end of the filter to one week before the start date.
Draft Latest edits on