How to select dates between START_DATE and END_DATE fields with one Date Picker

megasupermoon — Thu, 20 Apr 2023 08:26:23 GMT

Hello,

I have Pivot Table that have medication information with PATIENT_ID, START_DATE, MEDICINE_NAME, MEDICINE_POTENCY and EXPIRATION_DATE. There's also Date Picker, and when the user selects date range, the report should show only those medications that are valid within selected date range. For now Date Picker gives medications whose START_DATE is within selected date range, regardless of whether the medications have expired or still valid.

How to make the report and Date Picker work as desired or is it even possible? Is this done with code/query or in the report side?

Thanks for advance!

Re: How to select dates between START_DATE and END_DATE fields with one Date Picker

edwin — Thu, 20 Apr 2023 18:03:05 GMT

the behavior is really dependent on your data model. i would guess that the date picker and the start date are associated. you will need to make a bridge table that connects both your start and end date so you can control whether the selected date applies to the start date or expiration date.

can you pls at least share your DM?

topic Re: How to select dates between START_DATE and END_DATE fields with one Date Picker in App Development

How to select dates between START_DATE and END_DATE fields with one Date Picker

Re: How to select dates between START_DATE and END_DATE fields with one Date Picker