Date Variable Between and To - No Data Returned

[ivandrago]

Hi,

I have a sales data model which joins to a date calendar table. I have a list box for the fields from the calendar Day, Month, Year so the users can select the dates they wish to see. I also have a calendar object that looks at two variables vStartDate and vEndDate, when the user clicks on the macro button next to these objects it will execute the following Actions

='=Date >= vStartDate and Date <= vEndDate'

The problem I am facing is that there are some invoice dates where there hasn't been any invoices done on that day i.e. a weekend but if the users entered these dates then Execute the results, they are non the wiser it is only when looking at the current seletions that the filter for the action is not met. Any ideas on how to warn users that their conditions are not valid?

Thanks

[Michiel_QV_Fan]

Add 2 listboxes with the possible dates from the calendar and abandon the macro? Then the user will only be able to select enddates that are valid for the startdate.

[ivandrago]

Hi,

The calendar is used for another data model as well where the data model is concatenate under the sales model, I have hard coded field called Ty[pe to determine the difference between the two, so the date could be valid for the other model.

Thanks

[ivandrago]

How would do the possible dates anyway? Do you have a example?

[Michiel_QV_Fan]

The dates from the calendar are linked to your invoiced date's somehow?

Or is the calendar not linked to the datamodel? Which can be very usefull.

Can you post a screen print form the table viewer? (ctrl+t)

[ivandrago]

Please find attached the Document I have the issue with.

[kamal_sanguri]

Please look at the attachment, I have made some changes and it should work the way you want.

Thanks,

Kamal

[ivandrago]

Thanks for this Kamal.

Is there anyway of alerting the users to say that the date they have entered does not appearing in the current selections because there is no data for this?

[kamal_sanguri]

Check this out.

Thanks,

Kamal

[kamal_sanguri]

Hi Ivan,

If helped.. please mark this question as answered.. thanks

Kamal