Dates Logic Help

[abhaysingh]

Hi Guys,

I have dates like in one table

01-01-2015,

01-02-2015,

01-03-2015

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2015

01-11-2015

01-12-2015

i want that first3 month Dates will change to

01-01-2016,

01-02-2016,

01-03-2016

but when i click Jan it shud give me 01-01-2016 rather than 01-01-2015

how i can achieve that?

pls suggest

[swuehl]

I don't understand what you are trying to do.

Do you want to create a financial calendar that ranges from April 2015 to Mar 2016 for FY 2015?

[datagrrl]

Maybe an example QVW would help. Are you talking about a month filter/list box?

[abhaysingh]

Hi Guys,

I have Year and Month as per Fiscal Year in a table, like year 2015 and their Month 

Apr,May,Jun, Jul ,Aug, Sep,Oct,Nov,Dec,Jan,Feb,Mar

So i want to create the date like below

01-01-2015,

01-02-2015,

01-03-2015

01-04-2015

01-05-2015

01-06-2015

01-07-2015

01-08-2015

01-09-2015

01-10-2016

01-11-2016

01-12-2016

kindly suggest

[avinashelite]

Hi Abhay,

Could you please explain your requirement in detail ?

According to me you could create a master calendar according to your need and link with your data .

Creating A Master Calendar