I have a process that I am trying to schedule for automation, but have been unable to figure out the correct date calculation, or an alternative method of setting the correct WHERE clause.
The table that I am hitting has enough data in it that I can only export up to 3 days worth of data. Beyond 3 days, the resulting export files are too large to transport and transmitt (1 day .txt export file is approximately 60mb). I do not have an issue with using 1, 2, or 3 days of data, the only difference is how I set up the task scheduling. The hitch though, is that the data that is populated to the table has a 3-day delay, so if the WHERE clause uses /Today/ or /Yesterday/, there will not be any results. To account for holidays, I would like to use (basically) DATE = TODAY - 4, but I have not been able to determine how to set up the correct format for WHERE clause, in the builder or the editor.