I'm working on a project where the data gets updated every Monday (an XLSX file which I bring into a File Geodatabase and work with from there). I've been tasked with automating the data massaging. One of our fields contain dates and users are interested in features dated 3 weeks before today's date and 3 weeks after today's date.
Working manually I would just sort the table and select features that match the time criteria then code them accordingly (there is a second field for the coding) but how do I achieve this in ModelBuilder?
I know how to export a selection, but I have no idea how to select a dynamic date threshold. I'm at a loss.