Running a workspace weekly without using FME Server.

Hi @mmcmahon​,

You could use DateTimeStamper to get the current date, then a couple of DateTimeCalculators to get the upper and lower date based on that timestamp. So, if you run the workspace on Monday, but want a Sunday to Sunday window, you can use the first DateTimeCalculator to subtract a day and the second to add six days. You may want to add a DateTimeConverter to round the datetime stamp to the nearest day before the calculations.

Hi @daveatsafe​ 

I followed what you described and I was able to create 2 columns with the have dates for the beginning of the week and the end of the week. How can I get the dates in between the week?

This is what I have so far. I just swapped out the datetimestamper for attributecreator for testing purposes only.

Hi @mmcmahon​ . If I understand correctly, you could query the geodatabase with a where clause to return any data collected within the start and end date ranges.

If you have a capture datetime on the records, the simplest solution may be to calculate the difference between the capture datetime and timestamp, the use a Tester to test the range of that difference: