Stop showing data after a certain date/SWITCH to 0?

I have a table of agents and their promotion date (thanks to this community!) and now I'm looking for a way to have all data from the agent show UNTIL that promotion date (X). So anything after that ...