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 Mike Lewis 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: *

  1. joneas212

    How to add random minutes to a time field?

    Thanks Pete ... I really appreciate your assistance. I discovered that the date field was actually in String format so: IF ISNULL({Monitor_Tool.service_end_time}) THEN ToText(TIME(DATEADD('n', {Monitor_Tool.duration_service}, CurrentDate + CTIME({Monitor_Tool.service_start_time}))),"hh:mm...
  2. joneas212

    How to add random minutes to a time field?

    Certainly that's what I've been working to get .... but i cannot get anything to work. //{Monitor_Tool.service_end_time} = ({Monitor_Tool.duration_service} + {Monitor_Tool.service_start_time}) //sum({Monitor_Tool.duration_service},{Monitor_Tool.service_start_time})...
  3. joneas212

    How to add random minutes to a time field?

    I am fairly new to CR and have used these forums with great frequency and really appreciate all the great support it has provided. However, i cannot find a satisfactory answer to my problem .... perhaps I'm just trying to overthink this. Here is the problem: When the report was first created...

Part and Inventory Search

Back
Top