0
Highligh patients with symptoms
I have a database with a main table with the names of the patients and a one-to-many connected table where I insert the visits of each patient. At each visit I mark whether the patient has new symptoms at that moment (new symptoms field is a yes/no field ). Now I need to see all the patients who in a given period of time for example between 1 January 2022 and 31 December 2022 had new symptoms. Can you help me please? Many many thanks. Massimiliano
1 reply
-
Hi and welcome to the Ninox's community!
Maybe you are looking for something like:
select 'Visits' where 'Symptoms' and 'Date' > date(2022, 1, 1) and 'Date' < date(2022, 12, 31)
Content aside
- 1 yr agoLast active
- 1Replies
- 32Views
-
2
Following