Are you want to change the date field for december to "20121130" or exactly one month back? for ex: 20121202 goes to 20121102 or 20121130?
IF(Tier = 'Quint' and MonthName(DATE_FIELD) = 'Dec 2012',AddMonths(DATE_FIELD,-1), DATE_FIELD)
//if your date format is not in standard format , use like this
Hope it helps
If you look at my attachment from the original post, the accounts and data are showing under June, I would like to move them to May (I used Nov and Dec as an example). Basically some sort of IF statement to manipulate my data when I select it. As my question header says, I need to reassign anything under once month/year, under that "Tier" to be categorized into another month.
anyone have any experience with this?