Search results for query: *

I need to count Member A in May, June, July, Aug, Sep, Oct and Nov. The auth is considered open until the end_date which in this example is 11/4/08.

I need to count the number of members that have an open auth by month. However, I'm having an issue because I only have an auth begin date and an auth end date. The data looks like this: Member A Eff_date = 20071201 End_Date = 20080531 Member B Eff_date = 20080101 End_date = 20080331...

I need to union the following query. I keep getting the error:error converting data type varchar to numeric. The data types of each field are: region varchar carrier varchar pcpname varchar avgrisk numeric effmonth smalldatetime endmonth smalldatetime mm int hic nvarchar prempay money proj08...

Duh, thanks a bunch

The query I'm trying to build pulls data from the day before. For example, on Tuesday – Friday previous day and on Monday I'm pulling Friday through Sunday. This is the date query I'm using, but I'm getting null values for effdate and enddate. Can you please take a look at it and let me know...

Worked perfectly! Thanks!

I'm trying to do a formula in Crystal 10. I want to highlight lines that have a ymdend >= {@EFFDATE} and <= "last day of month of {@EFFDATE}" For instance, I want the lines to be highlighted when the ymdend is between 08/01/2006 and 08/31/2006. This is what I have so far.... IF...

Worked like a charm. Thanks!!

I need to create a formula that will give me the last day of the current month (ex. 2006-11-30)