Help me out QV Community, I have some accounts that were placed with us at the beginning of say December that were Supposed to be placed in November. I don't want to manipulate the database because we want to actually know the placed date, yet I want them reported for November. Would I just have to do some sort of renaming of the Month in the script? How would I do this with multiple field criteria like below.
Basically if the field TIER is "Quint" and then DATE_FIELD is "20121201", I want all those December dates to show up as November dates in the DATE_FIELD, but only for that month if it is that TIER.
This is what I was thinking of using but not sure it is what I need
IF(Tier = 'Quint' and DATE_FIELD='20121201',20121130,DATE_FIELD) as DATE_FIELD
Re: Reassign Accounts in one Month to Another Month
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.