Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
use matibox
hi
Do use multibox
or use a table and check on dropdown list.
check them. Left mutlibox,right a table box.
HTH
Ravi N.
Hi Sunil,
I tried multibox but it doesn't give me the output as per the image. Or probably I'm missing something.
Say In the list box, click on the field, scroll down to the bottom, choose Expression and type =Date(<your date>,'MMM-YYYY')
I can use Table Box but how do i format the date field in there - Date(<your date>, 'MMM-YYYY')
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
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
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
Thanks, Sasikanth. This helped.