Search results for query: *

Still having some trouble... the problem is between Dec 31 and Jan 1. How do you make Crystal count this as a datediff of 1 day instead of 364? TIA.

Yeah but that just extracts part of the date, no? I figured a workaround by defaulting the year to 1999 for all the date fields. Example: date(1999,month(datefield),day(datefield)). This way I can retain it in a date format for when I do a datefiff function.

Hello, I was wondering how to extract JUST the month and day of a date field (yyyy/mm/dd) in Crystal? Example for 2014/01/06 I just need 01/06. Eventually I need this field to do a datediff with another month/day field so just changing the formatting doesn't work. TIA.

Hello, I'm wondering if anyone knows how (or if it's even possible) to calculate "bed days" in Crystal? I work in a hospital and require to report how many beds were occupied each day. The only fields I have access to are date of admission and date of discharge. For example, if a patient was...

Awesome!!! That worked perfectly, thanks a million.

Thanks!!! That worked perfectly.... however I have a new dilemma now I have to add a new group to the existing report: Program 1 08/29/2011-09/04/2011 100 09/05/2011-09/11/2011 80 09/12/2011-09/18/2011 94 Program 2 08/29/2011-09/04/2011 24 09/05/2011-09/11/2011 78...

Thanks LB, I tried the formula you posted in the thread and it seems to work if I convert my group sum to a text field (your formula references a string field). However I can't calculate the median/percentiles on string values so how would you set the group sum to a number array? I'm not too...

The problem is you can't do a running total on a group sum, as far as I know.

Does anyone know how to compute the median and 25th percentile of group sums (or average) without doing TopN sort? My report shows sums for each week (custom grouped Monday-Sunday) 08/29/2011-09/04/2011 100 09/05/2011-09/11/2011 80 09/12/2011-09/18/2011 94 .... I don't want to change...