Effective use of date field and Calendar in a QV application
Hi,
I am working on the application where I need to populate the datasheet on screen according to selected year/years and month/months or by specific date. I have multiple columns on that datasheet which contains date field. I am sharing the screen shot of it.
The year and Month field should get populated with the distinct year and month which contains last 8 columns. And on selecting particular year/years and month it should only populate the records which contains the selected year and month.
After after clicking "By Date" field, it will hide the year and month tab, and it will show calendar selection option as follows:
It should automatically populate the From date as the minimum date from all of those eight columns and in To Calendar it shouldn't allow us select the date less than From date.