All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
RE: Paul MacDonald's query below, I was having a similar conundrum, but was able finally to figure out that @time.queued yielded a number that represented the number of seconds since 1 Mar 80. (A query to Meditech did not reveal this; I had to puzzle it out for myself.) In order to convert a standard date to the proper format for selection, I had to use - first - the Z.date.clinical(@date) and then multiply it by 86400 (the number of seconds per day) to get a number that would approximate the @time.queued. The attached report is a RAD download from NMI that uses this logic. The calculation is in the macro "start". Note that the second date uses date+1; this is because selecting T-1 to T-1 would only give me a 1-second window instead of a 24-hour one. Also look at the select criteria on Page 2 for the completion of the logic. ====================================== Hello folks, I'm having difficulty trying to get my NPR to allow me to select by an internal date when I use the 'T-XX' format. I would like to schedule a report to run based on a field that is in the internal date/time format (seconds from 1 Mar 1980). I am using the following: xx.date DAT=FREE JFY=L LEN=10 VAL=%Z.date.clin.to.out(@time.queued) When I try to use xx.date in my selection on page two, it doesn't recognize the common format of 'T-XX' (i.e. it doesn't expand out to the corresponding date), and no results are returned. If I type in the actual dates (mm/dd/yy) and the report runs fine. If I change xx.date to DAT=DATE, the 'T-XX' format expands out on the screen, but I get no results this way either. I would like to schedule this report to run on a daily basis, so I need to have the 'T-xx/S' in order for it to work. Any suggestions??? Paul MacDonald Clinical Application Specialist Civista Medical Center 8 Kent Ave, LaPlata, MD 20646 (w) 301-609-4490 (p) 301-396-0698 _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
nmi.npr
Description: nmi.npr
_______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
