Is this possible to do in Enterprise Guide filter? I usually do a date compare in a filter like this that works fine: datepart(exit_date) >= '15Aug2017'd However I would like the to set it up so the year is dynamic, something like: '15Aug' || PUT(YEAR(Date()-181), 4.) This code produces the correct character format I want 15Aug2017, but I can't just put a 'd' at the end to assign it as date constant for comparison. Any suggestions would be much appreciated. Thanks, Kenny. EG 6.1 SAS 9.4
... View more