COMMUNITY HEALTHCARE USER GROUP Forum

babbott

@babbott

Forum Home | Recent Posts

Active Member

Joined: May 13, 2019 2:37 pm

Topics: 3 / Replies: 5

Topic

4 years ago

Forum

MEL, SQL, Oracle

Replies: 1

fantastic! that worked. thank you for your help!

5 years ago

Forum

MEL, SQL, Oracle

I'm getting an error using this match function. maybe i'm not using it correctly? {if match(OBSPREV('FORMPROBLEMS'),'Conjunctivitis')>0 then ‘yo...

5 years ago

Forum

MEL, SQL, Oracle

Topic

5 years ago

Forum

MEL, SQL, Oracle

Replies: 5

thank you all. final code: {if DURATIONDAYS(LASTOBSDATE('FECIMMTEST'),str(._TODAYSDATE)) > 365 then MEL_ADD_ORDER('T','Labs','Fecal Immu...

5 years ago

Forum

MEL, SQL, Oracle

thank you again!

5 years ago

Forum

MEL, SQL, Oracle

That works for the if/then logic and order, but I can't get it to display HEMOCULT due date. any ideas?

5 years ago

Forum

MEL, SQL, Oracle

Topic

5 years ago

Forum

MEL, SQL, Oracle

Replies: 6