Search results for query: *

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

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

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

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

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

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

thanks a bunch. works great!

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

Thanks synapsevampire! Works perfectly!

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

Thanks Naith! Problem solved!

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?

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

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?

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

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

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

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?