Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!!
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.
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.
Try in the month list box to check "Always one value selected".
Also can you please post the sample QV file ?
I can't check that box because it's a calculated field:
=month(OrderDate)
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!!
Thanks Rajni,
i figured out that this must be the solution and it worked.