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!

Register Log in
  • Congratulations Rhinorhino 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: *

  • Users: willpp
  • Content: Threads
  • Order by date
  1. willpp

    calculating how old a client is from 2 dates

    Hi Is it possible to calculate how old a client is from the {CLIENT.Date of Birth} and when a client {REGISTER.Date of Registration} field Regards Paul
  2. willpp

    how do i add a date of >= to this formula

    if isnull({CLCONT.Type}) or {CLCONT.Type} <> "UDES" then "" else {CLCONT.Type} something like this {CLCONT.Date of Contact} >= Date (2010, 02, 01) any help would Grateful PW
  3. willpp

    tying to show the client once even when the client has had multiple co

    if isNull({CLCONT.Type}) THEN "UDES" ELSE 'BLANK' what i am trying to do is show clients that have not had a "UDES"({CLCONT.Type}) when i put paramiter of does not = UDES the reports shows all the other contacts that the client has had how do you show the client once
  4. willpp

    Grand total for times

    got this working and it puts all durations into Hour and minutes so this sorts the first part but then i want to add a grand total for hours and minutes any help would be grateful First part of formula local numbervar Hr := Truncate({ADCONT.Duration}/60); local numbervar Mn :=...
  5. willpp

    How do you change minutes into Hours

    at present it shows as 65 minutes duration but i would like it to show as 1 hour 5 minutes then add a grand total in hour and minutes I would be grateful for any help

Part and Inventory Search

Back
Top