01-28-2015 02:19 PM
I'm having issues trying to recode a column to display the Fiscal Year (FY) for a particular range of dates. In the "Specify a Replacement" dialogue box using either the Replace a Range or Replace a Condition tabs, If I use anything other than the formatted SAS dates available in the drop down I either get a syntax error or the query will run but no results will populate.
Attached document with screenshots.
Any help would be appreciated.