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

    Desktop GUI vs. HTML GUI

    I need to find out the differences in the "look and feel" of the desktop GUI and web-based GUI. I am implementing an end user training solution for a client who is using both GUI versions, and need to make sure that training will be virtually identical regardless of the GUI type (besides the...
  2. farrelm2

    Need report example with page up, down,, etc., drill down, capability

    I need to find an example of a report that has the ability to do the following: -Use the first page, next page, last page, previous page buttons -Has the ability to drill down to a lower level of the report -Can be sorted and totaled This example CANNOT be a accounting/finance report. Any info...
  3. farrelm2

    select expert/group selection

    I used the second post to group by. How can I hide all instances that return 0?
  4. farrelm2

    select expert/group selection

    The time value that I need to define is a range. I am using DateDiff(&quot;h&quot;,{cm3rm2.down_start},CurrentDate) >= -164 and DateDiff(&quot;h&quot;,{cm3rm2.down_start},CurrentDate) <= 4 When I use this formula, from you're first reply, in record selection, I get no results: {cm3rm1.status}...
  5. farrelm2

    select expert/group selection

    I am creating a report that is grouped by a variable which has 3 statuses. This is a basic report that merely lists all instances where variable j <> &quot;k&quot;. I need a formula that will do the following: List all instances when status=a and j<>&quot;k&quot;, and status=b, and j<>...
  6. farrelm2

    need a field to show the last day of the previous month

    I am using the lastfullmonth function in my report. I will be running the report on the 1st day of every month. On my report, I need to print a field to show the last day of the previous month. For example, I ran the report on Oct. 1, but need the report to read &quot;For month ending...
  7. farrelm2

    formula :aged 91-120 days

    thanks a bunch. works great!
  8. farrelm2

    formula :aged 91-120 days

    I need to create 2 'aging' formulas. One aged 91-120 days, and another more than 120 days. any ideas?
  9. farrelm2

    date formula

    Thanks synapsevampire! Works perfectly!
  10. farrelm2

    date formula

    I need to set up formulas to output Monday's date of the current week, first day of current month, and first day of current year. For example, if I run my report tomorrow (Tuesday), I need 3 formulas for 3 different outputs. The outputs are: one that reads October 7,2002,(Monday of this week)...
  11. farrelm2

    convert date/time to string

    Thanks Naith! Problem solved!
  12. farrelm2

    convert date/time to string

    Yes, I need to alter my data by 4 hours. Your datediff or the currentdate+7 formulas will work to capture the correct instances, but I need another formula to subtract 4 hours from my times. Where would this kind of formula go?
  13. farrelm2

    convert date/time to string

    I am not combining this with the currentdate+7 clause, but I understand how the 168 works. However, besides gathering all those instances, I need to subtract 4 hours from all those times. Currently an instance on my report reads 10/8/02 12:00 pm, but should read 10/8/02 8:00am, because of time...
  14. farrelm2

    convert date/time to string

    Naith, Your formula works to capture all instances 7 days or less in advance, but the time that I need to report must READ 4 hours less than what the times read now. Any suggestions?
  15. farrelm2

    convert date/time to string

    The date range now works correctly, but adding the datediff formula brings up no results. The following is my record selection formulas: {cm3rm1.status} <> &quot;closed&quot; and {cm3rm2.down_start} <= currentdate+7 and {cm3rm2.down_start} >= currentdate and...
  16. farrelm2

    convert date/time to string

    Also, using datediff(&quot;h&quot;,-4,{MyTable.MyDateTime}) gives me an error at '-4' saying a date is required here.
  17. farrelm2

    convert date/time to string

    If I were to run the report today, I would need all instances from 10/4-10/10. It is a date field used for scheduling purposes. Using the {MyTable.MyDateTime} >= currentdate+7 did not give me the correct data, it only brought up the one instance that was scheduled past 10/10. And how do I...
  18. farrelm2

    convert date/time to string

    I need to report on a date/time field and use a formula to capture all instances from today for one week. I converted the date/time to string because I also needed to subtract 4 hours from the time because of time zone issues. I do not know how to do both. Any suggestions?

Part and Inventory Search

Back
Top