How to create drop down list from a Date field

[#1]

Hi,

I have a date field that i want to use in a drop down list (Please refer the image below). The date field has multiple values, hence i cannot specify hard coded values in any of the drop down object field. Can you please help me in creating the drop down list object?

Since I'm using the free version of QV, please provide detailed steps to achieve this. Thanks in advance.

[SunilChauhan]

use matibox

[Anonymous]

hi

Do use multibox

or use a table and check on dropdown list.

check them. Left mutlibox,right a table box.

HTH

Ravi N.

[#4]

Hi Sunil,

I tried multibox but it doesn't give me the output as per the image. Or probably I'm missing something.

[#5]

Say In the list box, click on the field, scroll down to the bottom, choose Expression and type =Date(<your date>,'MMM-YYYY')

[#6]

I can use Table Box but how do i format the date field in there - Date(<your date>, 'MMM-YYYY')

[sasikanth · Accepted solution]

HI Mohita

use table box and for making your date in to that format

Do that one at your script levele it self

some thing like

Load

date(<date-field>m'MMM-YYY') as Mydate,

.

.

.

from....

.......................................

may be helpful

[PradeepReddy]

We can achieve this in 2 ways

1) at script Level

    Create a field "Month(Date)&'-'&Year(Date) as MonthKey ".

    use the MonthKey field in List Box.

2) at sheet level

     Create a list box, with the expression.... Month(Date)&'-'&Year(Date)

Regards,

Pradeep

[avinashelite]

Hi Monita,

If u want the exact representation go for the Calender Object and in the Data field select expression and use the Date(fieldname,'MMM-YYYY') function . This will give u the similar representation.

Regards,

@vi

[#10]

Thanks, Sasikanth. This helped.