Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dugjohnson

    Date Parameter to UFL

    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.
  2. dugjohnson

    Date Parameter to UFL

    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
  3. dugjohnson

    Get DateDiff in milliseconds

    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.
  4. dugjohnson

    Date Parameter to UFL

    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...
  5. dugjohnson

    DISTINCT problem

    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...
  6. dugjohnson

    Delphi 7 + Crystal Report 9 Dev. Edition

    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.
  7. dugjohnson

    DISTINCT problem

    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...

Part and Inventory Search

Back
Top