Django, you rock. That is exactly the info that I needed. The other info on how to redesign futures apps was also valuable for my brain needs, but this solved the current emergency.
And if I controlled the horizontal and vertical of this internal app, I would do that. This function is just one of several that I am working on.
I am still in the dark as to how a date is passed to a UFL.
Doug
Depending on how you are storing the millisecond information, you can convert it to a multiple of an integer, do the math, then divide it out. But you need to have stored the time information with the appropriate level of detail in the first place.
I am writing a UFL that figures lag time between a customer contact and response by tech support, pulling out non-working days.
One of my functions
Boolean: IsBusinessDay(Date)
takes a date as a parameter. As a test I am passing it CDate('01/01/2004') which is showing up in Delphi as 2453005...
Sorry, I didn't mention that I did that. I get a record for each patient AND exam date, so that if the patient is seen twice in a period, there are two records that get counted. I need to count 1 for each patient that is seen in a period, no matter how many times they were seen.
I'm thinking a...
My understanding is that the VCL will work with 9.2.3, but there is a Hot Fix that you have to apply after the Service Pack to accomplish. I was looking for installation information and stumbled across that tidbit yesterday, but am not 100% on it.
I need to do a mess of cross tabs based on whether a patient has had services in a given period. And while I am at it, I am counting their family members in the crosstab too. By linking the exam table to the patient table, then linking the patient table to itself as an alias via the family...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.