Search results for query: *

Can a variable be used in record selection? I have a report that is calculating workdays and holidays based on the formula from Ken H. and is working correctly. However I want to limit my record selection based on the formula. Please help Sharon

I have a date field that shows the exact date the service was performed, but on my report when it displays they only want it to display back to the first of whatever month it is in. Is there a formula that will convert it for me? Example if the date shows 09/15/2003 I want it to display...

Thanks to both of you. This worked great.

I have a patient list that needs to pull those patients that will turn 65 within whatever time frame the end user wants to specify. How do I write the formula to find those patients in the record selection?

I have this query that someone wrote in our company with the sql designer. I would like to create this in a Crystal report but do not know how to do the having piece. We have members that have more than one eligibility record, but want to find only those that are effective for a certain month...

I have a query which right now is subtracting two dates and then returning only those records which are <= 5. Here is a sample from the where clause: (av.status_date - av.requested_date) <=5. We have to report Turn around times and need to exclude weekends and holidays. Can anyone tell me how to...

I am trying to calculate two date fields to get the number of days between. My report will pull patients that were either admitted or discharged within the data range specified. If I choose January as the month I am looking at, I will have some records that will show patients admitted prior to...