Creating a boolean calculation followed by a date function
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.