Search results for query: *

I'm trying to figure out how to find data within a 4 month period. So when the report runs, it should pull data for the last month(1 month back) + 3 months. So if I run the report now, it should pull all June, July, August and September. Can someone please assist with this. I have this formula...

I'm trying to pull data based on a date parameter. So when the last date of the month is entered in the parameter field, it pulls all data for that month. In addition to this, I also want the report to pull data for the prior month as well. Can someone assist with this problem?

How do I write a function to highlight when it's within 2wks of currentdate. This is what I have currently and it is taking everything after the 14 days. I want everything from 0-14 not after the 14 days if currentfieldvalue>=dateadd('d',14,currentdate) then crYellow ELSE crNoColor

I created 2 optional parameters and have a couple of formulas for the user to either enter something or leave blank. They both work separately but wanted to combine them into one formula. Please see example below. When I put an else between the 2 formulas, it ignores the 2nd one. Can someone...

Is there a way to exclude the current date from a Max or Min formula? I'm trying to do a Max on a group of numbers for the past 5 years and one of them is from the current date. How do I exclude that from showing up? Any help will be greatly appreciated. Ginkoba

I'm using the below formula to derive the exact number of working days(-sat, sun) for the last full month. For some reason, each month, I have to manually adjust for 1 or a couple of days depending if the month has 30 or 31 days. I thought my formula was doing this automatically but some how...

I am attempting to build a report to display a huge text field with a couple of formulas(vendor name, address, zip) on the top first page. Each time I run the report I get just a few pages of a total of 11 to display. What am I doing wrong?

Hi all, I have a code that calculates the work days excluding saturdays and sundays. See code below. However, I want to further modify this so that "D1" would subtract 28 days for months 4,6,9,11 and 30 days for months 1,3,5,7,8,10,12 and so on and so forth. Please assist. Local DateTimeVar d1...

I'm trying to pull data using LastFullMonth. Problem is my count not accurate as this function ignores the time portion. Is there a way to include the time portion with LastFullMonth? my record selection is : {@end_date} IN minimum(lastfullmonth) to maximum(lastfullmonth)

I have a table with some null values in certain fields. I want to count all values as 1 including null values and fields that hold " ". This is what I'm trying to do but getting it all wrong: IsNull({@datetime}) and {@datetime} >= {?Start} and {@datetime} <= {?End} This does not work as I'm...

Is there a way to replace values in a database field? The database field is True/False and I want to replace them with Yes/No. About 25 records in all. How can I convert all of them?

Hi, I have a formula in my record selection as in: {FieldName} = "test" and {Status} Like "active" and {@purchasedate} IN MonthToDate I want to be able to display the month's name on the page header just below the report title as in: Report Title Through Jan 28, 2010 I also would like to...

I have a running total field that matches(line up) with the groups in a group header. Each time I try to do a graph, I do not see the running totals I created. How do I get the running totals on a graph?

I have a date in my database as a number: 1259632800000 (this should be 11/30/09) I'm trying to convert this to date but each time I do, I get the date off. Here's what's happening. When I apply the following formula: date({Command.TRIPLANNEDENDDT}/86400000), I get 11/30/1939. What am I doing...

Please help. new to the forum. Here is what I am trying to accomplish. I am trying to extract just this part from the below listed data in a descriptive field "08_December". Just the number and the name of the month. Is there a formula or code that I can use to do this and then group by that...