All our Transactions have a field called Posted Date and another field called Effective Date. In QlikView I load them like this, from daily text files:
DATE(DATE#( [Posted Date], 'DD-MMM-YY')) as [Posted Date],
DATE(DATE#( left([Effective Date],11), 'DD-MMM-YY')) as [Effective Date],
We run our billing cycle on the 10th of every month. So I want to give each Transaction a date matching the cycle the transaction will be billed. If it is between 11 October and 10 November, it will be billed on 10 November (November Cycle). If it is on 11 November it will be billed in December Cycle.
For some reason this is giving me the correct answers, but the answers are only in the correct format for certain months. Please see the attached picture. For months like June, July and September, it shows the month NUMBER and not name. This seems to only be a problem with EFFECTIVE date, even thought it is exactly the same as posted date (the format and load expression).
in ur 1st post u've used the condition day<11 which means else part comes into play when day>=11 which means for day=10 also the if condition rules (& not the else condition) which only returns the Month of effective date.