Prescriptions: issues with dates filters

[marthakeezy]

What went wrong? 😲

Raising after testing this issue: #6159

prescription dates

i have a prescription with a date of 28/01/2025. When I use filters, 27.01 to 29.01 seems to be working fine - however, as soon as I change the to date to be 28th, the prescription is not coming up. I think date filters should be including the date of the prescription - e.g. not greater than, but equal or greater than. Because if I as a user search for a prescription from yesterday, there is a chance i will be entering the exact date to bring it up.

prescription.date.-.included.mov

prescription dates again

i have two prescriptions from 24.01.2025. when i use from date and set it to 24.01.2025, only one of them comes up. should be two - the second one comes up if i set the date to 23.01.2025 though. something with the time conversion maybe?

Expected behaviour 🤔

As above

How to Reproduce 🔨

Steps to reproduce the behaviour:

1. Go to Dispensary -> Prescriptions
2. Create a few prescriptions for testing purposes (hopefully you already have some in the store!)
3. Play around with to and from date filters and note the above behaviour

Your environment 🌱

• Open mSupply Version: V2.6.0-build-test-3
• Legacy mSupply Central Server Version: V7.19.03

• Platform: Google Chrome (browser for Mac)

• Database type: PostgreSQL