Get a time frame in the query using the period column

[Marcus3081]

Hi,

I am new to the forum,
Here is a question I have a query which is linked to excel, and the period is input in excel, now the query has a period column which has a 12 month rolling period 201210 to 201309- as 201309 is the assumed to be the current month.



I want two extra columns derived by formula in the query itself- YTD and MTD depending on the data in the period column

Period	YTD	MTD
201210
201211
201212
201301	YTD
201302	YTD
201303	YTD
201304	YTD
201305	YTD
201306	YTD
201307	YTD
201308	YTD
201309	YTD	MTD

[Marcus3081]

Hi, It would be really great to get a solution on this, as I need to present it in couple of hours.......


Regards,
Marcus

[Dal Jeanis]

Unfortunately, not quite enough information about the underlying data to give you a quick answer. Sorry.