topic Re: get last date in App Development

get last date

earlcool — Fri, 27 May 2022 17:02:45 GMT

I have this compound statement I want to add another criteria last date visit (encounterDate).

if there are two dates 2019-06-05 and 2018-07-02 the last date is 2019-06-05.

=Count({<patient_id={"=Age >=18"}>}DISTINCT patient_id)

thanks greatly appreciated.

Re: get last date

vinieme12 — Fri, 27 May 2022 17:20:58 GMT

=Count({<

patient_id={"=Age >=18"}

,encounterDate={"$(=Date(max(encounterDate)))"}

>}DISTINCT patient_id)

Re: get last date

earlcool — Fri, 27 May 2022 18:04:16 GMT

Thanks for your response, unfortunately I am getting 0 records when I am sure

that I should get some.

Re: get last date

vinieme12 — Fri, 27 May 2022 18:12:21 GMT

Can you post a screenshot of the expression editor

And post some sample data as well, so I have clarity on what your data looks like

Re: get last date

earlcool — Fri, 27 May 2022 19:48:49 GMT

The patients makes a number of visit to different facilities I want the last facility that the patient visisted.

Its hard to explain if you require more information please let me know.

Thanks your help and your professionalism

Re: get last date

vinieme12 — Sat, 28 May 2022 02:32:32 GMT

So currently Encounterdate is a timestamp field and not a date field

You need to remove the timepart from the timestamp , create a new field as below

For example

Load facultyname,gender,patient_id

, Encounterdate as encountertimestamp

,Date(Floor(Encounterdate)) as encounterdate

From yourdataSource;

Then try the same expression again

=Count({<

patient_id={"=Age >=18"}

,encounterDate={"$(=Date(max(encounterDate)))"}

>}DISTINCT patient_id)

Re: get last date

earlcool — Mon, 30 May 2022 13:54:17 GMT

I am trying to get something like this put I get zero

Re: get last date

earlcool — Mon, 30 May 2022 16:14:47 GMT

Data

Re: get last date

earlcool — Tue, 31 May 2022 13:40:59 GMT

Any help please?

Re: get last date

earlcool — Thu, 02 Jun 2022 15:04:11 GMT

I was missing a file