Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi All,
I'm sure I had this but I can't find it. I'm looking for a bit of script to build a calendar that has month-end in one column and 'report month YTD' in another column. eg:
Month End YTD Month
31/1/2010 31/1/2010
31/01/2010 28/02/2010
28/02/2010 28/02/2010
etc...
Can anybody point me in the right direction?
Thanks,
J
I don't understand excactly what do you try to do but here: How to use - Master-Calendar and Date-Values you will find various examples to build a master-calendar and also to implement various kinds of flagging like rolling periods, YTD/QTD/MTD, MonthEnd's and so on.
- Marcus