[MT-L] CS NPR Select Field Null Date

5 views
Skip to first unread message

Taylor, John

unread,
May 8, 2012, 3:01:30 PM5/8/12
to medit...@mtusers.com

Hi folks, does anyone know how to write the select field to look for a null date value?  In this example, BAR.PAT.subscriber.ins.eff.date – I’m looking for all where the field does not have a date value.

 

 

 

Thanks,

 

John Taylor

Revenue Cycle Analyst, Information Systems | Augusta Health

Office:  (540)332-4882 | www.augustahealth.com

 

Joe Cocuzzo

unread,
May 8, 2012, 3:28:41 PM5/8/12
to Taylor, John, medit...@mtusers.com

EQ “”

 

 

 


Joe Cocuzzo
Vice President
NPR Services

Iatric Systems, Inc.
Phone/Fax:
(978) 805-4115
Email: Joe.C...@iatric.com
Web: www.iatric.com


Iatric Systems is a leading provider of integrated software applications, interfaces and reporting solutions for hospitals and healthcare systems.

Visit us at MUSE booth 301

__________

Taylor, John

unread,
May 8, 2012, 3:30:38 PM5/8/12
to Joe Cocuzzo, medit...@mtusers.com

Duh.  J   Sometimes it is the simple things.  Thanks!

 

 

Thanks,

 

John Taylor

Revenue Cycle Analyst, Information Systems | Augusta Health

Office:  (540)332-4882 | www.augustahealth.com

 

Mitch Lawrence

unread,
May 8, 2012, 3:47:41 PM5/8/12
to Taylor, John, medit...@mtusers.com

subscriber.ins.eff.date EQ

        “”

 

 

 

 

From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Taylor, John
Sent: Tuesday, May 08, 2012 2:02 PM
To: medit...@mtusers.com
Subject: [MT-L] CS NPR Select Field Null Date

 

Hi folks, does anyone know how to write the select field to look for a null date value?  In this example, BAR.PAT.subscriber.ins.eff.date – I’m looking for all where the field does not have a date value.

image002.jpg
image003.jpg
image004.jpg
image005.png

Purvins, James A.

unread,
May 8, 2012, 3:51:14 PM5/8/12
to Mitch Lawrence, Taylor, John, medit...@mtusers.com
I always forget if checking for a NE null or EQ to null is Kosher in NPR report writer.

I know you have to be careful when you check for null in your own code (i.e. macro)
 
Jim Purvins

From: meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Mitch Lawrence
Sent: Tuesday, May 08, 2012 12:48 PM
To: 'Taylor, John'; medit...@mtusers.com
Subject: Re: [MT-L] CS NPR Select Field Null Date

image002.jpg
image003.jpg
image004.jpg
image005.png
Reply all
Reply to author
Forward
0 new messages