Search results for query: *

I need to rephrase my question though: I have a datebilled column, and I need to show all the claims that were datebilled including that datebilled within the last three years. Does this make any sense?

Hi, How would you write in the select record to list all records from a date field to the last 3 years? should I use date diff from currentdate to ????

How would you then change the date to MONTH YEAR as in Jan 1999?

Hi, I need to write a formula to change from date format xx/xx/xx to month format such as Jan, Feb, etc... How would you write that case? Thanks, C

Hi, Would someone help me write this formula? Here's my data: ID Service Beg Date End Date 1234 H1111 8/18/2010 8/20/2010 1234 A148 12/16/2010 1/16/2011 1234 B1498 8/16/2010 9/15/2010 1234 H1111 8/11/2010 8/12/2010 1234 98104 8/18/2010 9/15/2010 1234 H2011 5/16/2010 9/30/2010 I have a date...

Oh yes, I meant no service codes should appear in both main report and sub report. when I put that formula in my selection record area, it seems to jumble up since I have other selection criteria as well.

I'm confused. Am I putting that formula into my main report or in my report selection record formula? My end results should be that no ID should be in the sub that are showing up in the main report.

Also, where would I put the formula on my main report?

How would you write the IF's formula in the main report if I want to show all data in that "x" row? ( I need to show ID, Service, Beg Date, End Date) ( I meant to say that the "x" is the result row) Thanks!

Hi, Would you please assist me with this? I know what I'd like to see on my end-results, but I'm not quite sure how to go about it. "X"s are the results on my main report, and "Y" is the result on my sub-report. Here's my data: ID Service Beg Date End Date 3549 H1111 8/11/2010...

Hi, I did a parameter on customer names, and it only pulls in up to the letter "I" on my list. Is there a limit on the parameter? how do you set it so you can see all of the list? Please help! Thanks, C

Thank you! It works!

Hi, How would I write a formula to change my service codes to the group code "Basic"? These are my service codes: 1) A123 2) S5286 3) H1111 4) H1112 5) H1113 6) H1114 7) H1115 8) H1116 9) H1117 10) H1118 I know how to write a case to change each service code to "Basic", but how would you...

I'm looking at my variable_set formula, and the dates are coming in correctly for the services, but when the results are not coming in correctly on the footer. It picked up the other date from the other service. I wonder why...

If I'm only looking at company 1 and company 2, the results should look like this: ID Company Services Date1 Date2 Date3 Date4 3 C1 S1 7/2/2011 7/10/2011 7/20/2011 7/25/2011 3 C2 S2 7/6/2011 but my results are looking like this: ID Company Services Date1 Date2 Date3...

Thank you. It works!!! Have a good day, --C

LB - No, it's not working... I'm still trying to fiddle around with the footer.... for some reasons, the dates got onto different services.... any other suggestions?

Hi, How would you write a formula to blank out the first five digits of a social security number? The output would be like XXX-XX-1111. Thank you! C

First, I thought I only need to show date1, date2 and date4 only. Now, I need to show the first four dates from any services. Thanks!

Thank you for all your help! I am still struggling with this, because I have 2 other groupings that I need to add to this. Here's my data: ID Company Services Date 3 C1 S1 7/2/2011 3 C2 S2 7/6/2011 3 C2 S1 7/7/2011 3 C1 S2 7/7/2011 3 C1 S1 7/10/2011 3 C2 S1 7/19/2011 3 C1 S1 7/20/2011 3...