cancel
Showing results for 
Search instead for 
Did you mean: 

To change the date format in the drop down

Former Member
0 Kudos

Hi,

I have a drop down in my VC Model. That drop down populates values for 'Fiscal Year' dynamically from a query.

The values in the drop down are getting displayed as 'Z1/2008', 'K1/2009' where K1 and Z1 are fiscal yr variant. This fiscal yr variant is actually compounding of Fiscal year.

But I want the values in the drop down to get displayed as '2008', '2009'. Does any one know the setting in VC for this?

Thanks

Vikrant

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Vikrant

Are you using 'Fiscal year key' in your chart / report? try with Fiscal year ext key or fiscal year text

I think this will solve your problem.

Regards

Sandeep