topic Re: Selecting specific year in set expression in App Development

Selecting specific year in set expression

andnichols — Tue, 03 May 2022 18:06:54 GMT

Hi,

I am trying to filter this data to just the year 2022, but the field "DepartEDDateTime" is a timestamp and I can't seem to get it to work in the if statement. Appreciate any help!

(count(if((DepartEDDateTime - LastReadyToAdmitDateTime)*1440 <=60 and [PatientClassName]= 'Observation' and year([DepartEDDateTime] = '2022'),[EncounterID]))

Re: Selecting specific year in set expression

edwin — Tue, 03 May 2022 18:34:07 GMT

an easier way would be to add a YEAR column in your data model. where you define or load the field DepartEDDateTime, just add a new field defined by year(DepartEDDateTime) as your yearfield

this way in your expression or et analysis, you jut qualify your yearfield equal something

Re: Selecting specific year in set expression

andnichols — Tue, 03 May 2022 18:41:26 GMT

That worked - thank you so much!

Re: Selecting specific year in set expression

edwin — Fri, 06 May 2022 17:51:32 GMT