Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: records333
  • Content: Threads
  • Order by date
  1. records333

    Data Point Flags for consecutive days with If Statements

    Hello, The end goal is to flag a patient record If measure value is consecutive for 2 days AND value increase >= 3 on 3rd day AND value is sustained for 2 subsequent days THEN FLAG Example: Measure Date Measure Value 20-AUG-13 5 21-AUG-13 5 [highlight #FCE94F]22-AUG-13 5 23-AUG-13...
  2. records333

    Interpret code that used a field that was a string and now the field is a number

    I inherited a report and I'm learning about variable. I would like assistance of interpreting and recommendations on how to refine: Extending code that uses a string fieldglobal stringvar a1cvalue := {table.LAST_VALUE}; if mid ({table.LAST_VALUE},4,1) = "-" then a1cvalue :=...
  3. records333

    Max Date and Correlating Value to be placed in ID Group

    I developed a report that displays the correct date ranges and values with consideration of the code in the Selection Criteria. And I created fields using If statements to capture pre and post dates. I am stumped when I attempt to select only the max date and correlating value in ID group.
  4. records333

    Evaluation lab value 6M before a class and lab values 3-6M after class

    Scenario: 1)capture lab values and dates 6M before class 2)lab values and dates 3-6M after class. My selection criteria is coded to capture date 6M before or after class. Additionally I would like to create columns pre a1c values and post alc values. (report is grouped by patient) I used a if...
  5. records333

    IF statements not evaluating

    During validation, I've notice that the formula is only evaluating the first statement not the OR STATEMENTS. Please see example: IF ( ({Command_DATE} in DateTime (2013, 07, 01, 00, 00, 00) to DateTime (2013, 12, 31, 00, 00, 00) AND {Command_ORDER.DESCRIPTION} like "XXX*" ) OR...
  6. records333

    Help with counting formulas

    I have three formulas that count if a patient attended resources A, B, and C. My goal is to count the patient once IF they attended at least 1 of the resources. I would like feedback on the best way to count the patient once.
  7. records333

    Records between Monday and Friday

    Goal: Identify patients that have upcoming appointments Monday through Friday from rundate (on Thursday). I used a dateadd formula {PAT_ENC.APPT_TIME} in dateadd('d',8,CurrentDate)to CurrentDate to capture appointments within the week of runtime. But user would like a list of appointments...
  8. records333

    Dateadd formula for crystal reports

    Hello All, I thought I nailed the code but records that I know should return aren't. My goal is to capture appointments scheduled 8 days from currentdate; {table.contact_date} in dateadd('d',8,CurrentDate)to currentdate
  9. records333

    I give...and need assistance with MINIMUM DATE AND CONDITIONS

    The objective is to capture patients diagnosed during a specific time frame and assigned to a specific location: Conditionsif ({CLARITY_LOC.LOC_ID} in [99999] and ({DIAGNOSIS.DATE} >=date (2012, 11, 30)) ) then {DIAGNOSIS.DATE} else if ({CLARITY_LOC.LOC_ID} in [88888] and...
  10. records333

    Capture 6M of data after 2M of start date?

    I would like to capture encounter dates 6M before test date, 6M after test date- starting 2M after test date {PAT_ENC_HSP.HOSP_ADMSN_TIME} < {Test.Date} and {PAT_ENC_HSP.HOSP_ADMSN_TIME} > ('m', +2, {Test.Date}) or {PAT_ENC_HSP.HOSP_ADMSN_TIME} in dateadd('m',-6,{Test.Date}to...
  11. records333

    IsNull and Not Null

    I would like to capture hospital admission type that are null AND capture values that are inpatient and emergency. I tried the following which adversely impacts all records. Any recommendations on the following code? ({PAT_ENC_HSP.HOSP_ADMSN_TYPE_C} in ["1", "2"]and isnull...
  12. records333

    URGENT ASSISTANCE PLEASE; DATE INTERVALS USING DATEADD

    Hello, my goal is to capture a patients' HBA1C_Last_ Date; 3M, 12M, and 24M AFTER last class. I believe the following formula should be modified (possibly removing the 6M logic). All valuable recommendations are welcomed, thanks in advance. {DM_DIABETES_ARCHIVE.HBA1C_LAST_DATE} <= {ICIC.1ST...
  13. records333

    DateADD, DateDiff, DatePart???

    I would like to capture PAT_ENC.APPT_TIME in last 24M from 11/26/2012, but I'm getting boolean errors: {PAT_ENC.APPT_TIME} in Dateadd ("m-24", 2012,11,26,00,00,00)
  14. records333

    Capture clinic rollout dates by location AND encounter date is specified

    Hello I would like assistance with following formula: if ({CLARITY_LOC.LOC_ID} in []//xxx and ({PAT_ENC_HSP.HOSP_ADMSN_TIME} >= date (2012, 09, 17)) ) then "location name" else if ({CLARITY_LOC.LOC_ID} in []//xx and ({PAT_ENC_HSP.HOSP_ADMSN_TIME} >=date (2012, 11, 26) ) ) then "location...
  15. records333

    Show patients not seen by current pcp

    I'm learning and I would like **HELP** on a formula that capture Patient panel for specific prov id and show patients not seen by current pcp. I have the following formula but it is not returning those NOT seen. {CLARITY_SER.PROV_ID} = "11111" and {PATIENT.PAT_STATUS_C} = "?" and...
  16. records333

    I would like to capture patients th

    I would like to capture patients that had a hospital counter and scheduled an appointment within 4 week. All attempts has failed

Part and Inventory Search

Back
Top