Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
megasupermoon
Contributor III
Contributor III

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

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!

1 Solution

Accepted Solutions
Rams-
Creator
Creator

Hi,

In expression you have to provide the START_DATE and EXPIRATION_DATE of the Medicines.

If you need further help can you provide the table.

 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

View solution in original post

2 Replies
Rams-
Creator
Creator

Hi,

In expression you have to provide the START_DATE and EXPIRATION_DATE of the Medicines.

If you need further help can you provide the table.

 

Hope this helps,

help user find answers ! don't forget to mark  a solution that work for you and click the like button!

megasupermoon
Contributor III
Contributor III
Author

Hey,

Thanks,  I'll come back to this if necessary.