AnsweredAssumed Answered

Creating a boolean calculation followed by a date function

Question asked by RobertT on Mar 23, 2015
Latest reply on Mar 25, 2015 by RobertT

Title

Creating a boolean calculation followed by a date function

Post

I'm trying to create a boolean function where I have a lists of patients who have a field for "number of medical scripts written"   these are random from 0-5 for each patient record.  I figured out how to use the boolean function to equal 1 for anything empty or "0" in that field.  I want to use a date calculation right now Im focusing on year.. to separate from 2014 and 2015 and eventually total up the amount of how many patients were written scripts during a given period   DOS= date of service random dates 2014-2015

i tried    GetAsBoolean ( NumberScripts)  &  DOS = Year ( "1/1/2014")

I figured get as a boolean would give me a count of one where each record had at least one script.  but I can't seem to separate that by year (or even a period of time)  if input that above of the date or even a date calculation.  My final goal is to create a report for this data.  Any help would be appreciated.

Outcomes