Could use your expertise in something, trying to format a date to be able to pull together a new column of fiscal months. So the data set has AccountDate which looks like: 01APR2014 (has 15 years of dates). I want to write my code so I roll up all dates into their respective months, so any date that falls between (April 1 and April 30 of 2014 goes into New_Month = April_2014). The data field is currently DATE9. Any help would be appreciated.
... View more