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 bkrike 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: mdahlen
  • Content: Threads
  • Order by date
  1. mdahlen

    SQL Expression string Date incorrect

    I am converting a string to a date field in an SQL expression and get the error 'failed to retrieve data from database - not a valid date'. The date entered was 10/50/2011. How can I determine if a string date is valid before I execute the rest of the SQL expression?
  2. mdahlen

    Parameter-multi-display on report header

    There is a dynamic parameter (numeric type) that is for locations--multi reponse. How can I convert those values to the name of the locations and display them in the report header? So, parmeter values are 13000, 14000, 14288. I want displayed on the report: Locations: Hospital A, Hospital B...
  3. mdahlen

    location name list from parameter

    My reports have a parameter for location that is based on the location ID (Number). I would like to display the location names (string)in the report header. So, if user picks loc_ID 14 and 13 then the report header will list Location Names "Main Hospital, West Hospital". Is there an 'easy' way...
  4. mdahlen

    no saturday or sunday

    Current turnaround time forumla is below. I want to exclude Saturday and Sunday from the equation. Suggestions? Thanks. I've looked at the DayOfWeek function, but not sure how to apply it. (DateTimeValue ({Report.date_signed_out},{Report.time_signed_out}) -DateTimeValue...

Part and Inventory Search

Back
Top