Month & day selection from list boxes

[bvmike2001]

Hello,

i have 2 list boxes:

1. with Month extracted from OrderDate field = order creation timestamp

2. with Day extrcted from OrderDate field

If i select one month from 1 list box and then if i want to select a day from the 2 list box, the first selection is cleared.

how can i solve this issue because i want to be able to select month and then day from this two list boxes if i want to find out how many orders i have in a sfecific day of month and for the calculation i made.

Thanks!

Mihai

[#2]

Dear Mihai,

I think that when you select a Month and then select a date,there is a possibility that the on that corresponding date in that particular month there was no Order placed.Please check and confirm.

Regards

Mhatim.

[bvmike2001]

Hello Mhatim,

no, is not such case.

I hve attached 2 printscreens:

1. month selection

2. day selection - you can see that tha previous month selection is gone and i receive results for all the orders created in 10 of june and july not just for june as i wanted to.

[#4]

Try in the month list box to check "Always one value selected".

Also can you please post the sample QV file ?

[bvmike2001]

I can't check that box because it's a calculated field:

=month(OrderDate)

[rajni_batra · Accepted solution]

u must have done this in front end, use the same expressions in Script n extract month and day then use it..

I was also having the same problem, Hope to Help!!

[bvmike2001]

Thanks Rajni,

i figured out that this must be the solution and it worked.