Im making a sleep diary. I have worked out the patient interface and data can be inputted. What I need to do now is get 2 weeks worth of data, separated into days, reported out.
The patient changes, and is tied to the practitioner. The date of the reporting isn’t known and its possible to have more than 1 reporting period.
What I have done is an RG that looks for all dates with an event (Events are like sleep, wake up etc) and groups together. Giving me groups of 14 days of data (all done properly)
I have a button at the end that send the dates across via URL and then Im trying to use that date to pull data out. For one reason or another I have had to use 3 different date types dd/mm/yyyy as text, mm/dd/yyyy as text and day, month, year, time as date.
What I had done is pulled over the 2 text dates and used the second to create an RG to pull event data in, which worked however I cant add 1 to increase the date with this. If I use the full date and format as needed it doesn’t work, even if I change to a text field.
Im now completely lost, Im just fuddling around. Can someone tell me a better way to do this. Ideally Id like the practitioner to search a patient of theirs, get a list of date ranges where there is events and pull a daily report from that but despite all my googling and reading I cant piece that together.