How to create a list box based on Month and relate them to database field

[ananyaghosh]

Hi,

I need to have make a list box based on the month and based on that, I have to link a database field to that list box.

the database field format is like that : yyyy-mm-dd. Now I want that when I select a month, my chart will change accordingly.

Thanks,

Sandip Ghosh

[nagarjuna_kotha]

Hi ,

Its Posible ,

example i have field>>> Emp_Join_Time

Ex :

Load

Emp_name,

Emp_Join_Time,

Month(Emp_Join_Time) as Month

From...............

If u do like this ,u ll get as u want

Regards,

Nagarjuna

[jagan]

Hi,

Try like this

Data:

LOAD

*

Month(DateFieldName) AS Month;

SELECT

*

FROM tableName;

Now use Month as Listbox.

Regards,

Jagan.

[vvvvvvizard]

Table1:

LOAD

Month(Date#((database field month name here),'yyyy-mm-dd' ) as the_month;

SELECT

"database field month name here"

from tableName;