I have an input sheet that will update weekly based on the date. This week is 'Available 18 Jun 2018' and next week will be 'Available 25 Jun 2018' and so on.
So to avoid a conflict with the header renaming every week when I repull the sheet and run - I used a select tool to rename the field 'Week 1'. I have a filter set up that has the expression '[Week 1] >= 20 AND [Local grade/Job level] != "Director"' (it did say "[Available 18 Jun 2018] >= 20 AND [Local grade/Job level] != "Director"' originally).
But when I output the data I don't want it to say Week 1 - I want it to be the actual week description (like Available 18 Jun 2018). I can't see a way to reference back to the original, so maybe I need to use a more generic name in the filter? What do you think?
TYIA for the help.
