Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Karchan
  • Content: Threads
  • Order by date
  1. Karchan

    Extract month and day from date field

    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.
  2. Karchan

    Calculating bed days in Crystal

    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...
  3. Karchan

    Median and percentile of sums or average in Crystal

    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...

Part and Inventory Search

Back
Top