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

null
    • szormpas
    • 5 mths ago
    • Reported - view

     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

  • 5 mths agoLast active
  • 1Replies
  • 32Views
  • 2 Following