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 Westi 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: dgoss
  • Order by date
  1. dgoss

    cell calculation problem

    I am trying to make a worksheet easier to use instead of using excel and a calculator. I have in the first cell 3900.00 and add 47,025.50 to get 50,925.50. I do this on a monthly basis. Next month I may have 3900.00 (same amount again) but it will not update the mtd or ytd total. Is there a...
  2. dgoss

    Text answers in a form.

    I have created a form ("quiz"). I have this quiz sent to me via email when it has been completed. I have answers that are true or false and then 3 questions require text messages. My question is how do I or can I specify the text to show up when the quiz is submitted? Ex. first...
  3. dgoss

    need duration of 2 dates for CR 8.5

    You were right and I also needed the "interval type" at the beginning. It worked, the report is done! Thanks so much for your help!!
  4. dgoss

    need duration of 2 dates for CR 8.5

    I think I'm almost there!! But I believe somewhere the syntax is wrong, Help! Datediff(NumberToDate(ToNumber({DH_DOCUMENT.DH_ISSUED_DATE}),NumberToDate(ToNumber({DV_DOC_APPROVAL.DV_READY_DATE})))
  5. dgoss

    need duration of 2 dates for CR 8.5

    Yes, the field is string. I'll try getting the NumberToDate, and see if that works. I have tried the DateDiff function too. It keeps telling me that it wants an actual date, I want to use the fields. Thanks!
  6. dgoss

    need duration of 2 dates for CR 8.5

    I have a report that shows the start date and the end date for each record. These 2 fields come from seperate tables, the data type for each is string, 8, format, yyyymmdd (20020402). I need to get the duration between these 2 dates. How is this best accomplished in CR 8.5. Thanks in advance...

Part and Inventory Search

Back
Top