Date, year(date) and month(date) question

[bailerie]

Hi,

I'm totally new to app development. and a beginner to QV but I'm trying to get two list boxes from the one date column. one for year and one for month. I've used the expressions year(Date) and month(Date) from the Date field on the table. however when I select for e.g. 2013 and then Jan:Jun in the month list box. It shows me Jan to June in all years.

Any suggestions greatly appreciated.

Regards

Dan

[#2]

Daniel,

You should create several fields or dimensions (Month, Year) during the load script

Fabrice

[#3]

Can you post a sample app?

[#4]

In Script editor

if u have date field,

then apply filed names like this

Year(Date) as year

month(Date) as Month

Day(Date) as Day like wise

so many functions are there still u if u want monthend(fieldname),Monthname(fieldname);

in load script u have to write

[bailerie]

Here is a Sample...

I'm not sure what the script should look like then.

[#6 · Accepted solution]

Hi Daniel,

PFA. I have taken a sample data from your script and done the changes accordingly. See the "Test" tab in qvw.

Key here is to create the Month & Year in script itself instead of creating them in front end.

Hope it helps!

[bailerie]

Thanks, That Works when I load in Script...