PDA

View Full Version : Bi-Monthly date calculation and results as the column header



sindhuja
04-01-2012, 12:40 AM
Hi,

i need advise on the below requirement.

Based on the current date i need to get past bi-monthly dates(fortnight dates).

For ex, today's date is 29.2.2012, the fortnight date for this peiod is 15.03.2012 and if the date is 3.3.2012 then the date value should be 29.02.2012 (last working date of that fortnight).

Can this be done automatically. I need to insert this date value to the column header after the last used column. and in the column header if the last column value is 15.01.2012 if am running the report now, the fortnight dates missing in the column header is 31.01.2012, 15.02.2012,29.02.2012,15.03.2012 and then this fortnight dates. Include all the fortnight dates as header till the date i run the report.

can i get a assistance on this pls..

-Sindhuja