Previous year date

[sivarajs]

Hi,

I have a date field like below

Date

5/28/2012

5/21/2012

5/14/2011

If i selects 5/28/2012 it should go to 5/28/2011 of previous year, if not it should give nearest value like 5/14/2011

How can i acheive this?

Regards

Sivaraj

[#2]

what do you mean " If i selects 5/28/2012 it should go to 5/28/2011 " ??

can you be more specific?

what are your sheet objects?

[sivarajs]

Its like previou year same date

i am using List boxes

[#4]

i konw that

the goal is what objects you've got?

as i understand your post, you've got two listboxes with date

making selection in one of them couses changing selection in other right?

it will be better if you post a sample file, to show the objects you have