Hi Jen, I think the following should work out for you: DFT=%Z.date.sub([ANS,"QUERY1"]|0,[ANS,"QUERY2"]|0) This will default the difference between two dates into a third query. QUERY1 would be the query with the greater date while QUERY2 is the query with the lesser date. Please let me know if you have any questions. Good luck, Brian Schmit Interface People, LP Mobile: 617-823-9326 Office: 214-222-1125 ext. 306 [EMAIL PROTECTED] http://www.ipeople.com <http://ipmail/exchweb/bin/redir.asp?URL=http://www.ipeople.com>
Does anyone have an attribute that will subtract two dates and give number of days? Thanks, Jen Brewer Beloit Memorial Hospital [EMAIL PROTECTED] 608.363.5859 =*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*= To subscribe or unsubscribe to the meditech-l, visit MTUsers.COM. To check the status of the meditech-l, visit MTUsers.NET. For help, email [EMAIL PROTECTED] ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
