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!

  • 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: *

  1. capronton

    DateDiff not calculating negative value

    There are two datetime fields "cTime" and "schedTime". I would like to ignore the "date value" in both datetime fields below and only subtract the "time values" For example, how can I subtract "cTime" from "schedTime" and ignore the date-part. On row 2 below, I only want to subtract 14:56 -...
  2. capronton

    DateDiff not calculating negative value

    LB/Ibass, The formula below is not working because the DateTime is not in two different fields. DateTime is only one field. Datediff("s",datetime({table.scheddate},{table.schedtime}),datetime({table.close_date},{table.close_time}) "cTime" "schedTime" "earlyLate" 6/18/17 15:29 5/30/17 15:24...
  3. capronton

    DateDiff not calculating negative value

    Thanks LB for all your help with this! Skip I apologize for not using the purple star to say thank you, and I will use the purple star next time. However, you should at least mention that I always say thank you in my message just as did above. Thanks again to ALL for the help you given me on...
  4. capronton

    DateDiff not calculating negative value

    Excellent suggestion! Please see dates for both schedule and close below. I notice that some schedule dates are different. How can I modify the DateDiff formula to handle this? "cTime" "schedTime" "earlyLate" 6/18/17 14:52 6/18/17 14:52 "OnTime" 6/18/17 14:56 5/30/17 15:00 "Late"...
  5. capronton

    DateDiff not calculating negative value

    Using the formula below, I get the data set below. The entire data set produces no "Early" If DateDiff ("s", {apc_correlated.sched_time},{apc_correlated.close_date_time} ) < 0 then "Early" else If DateDiff ("s", {apc_correlated.sched_time},{apc_correlated.close_date_time} ) > 360 then "Late"...
  6. capronton

    DateDiff not calculating negative value

    Notice that the second row says "Late" when it should say "Early" In fact throughout the entire report I get no "Early". Can someone explain? Thanks for your help. This is puzzling. "cTime" "schedTime" "earlyLate" 14:52:34 14:52:34 "OnTime" 14:56:58 15:00:00 "Late" 15:07:46 15:07:46...
  7. capronton

    DateDiff not calculating negative value

    Yes, they are both datetime fields.
  8. capronton

    DateDiff not calculating negative value

    When {apc_correlated.sched_time} > {apc_correlated.close_date_time} I should get an "Early" value but I do not. Can someone explain why DateDiff does not give me values less than 0? If DateDiff ("s", {apc_correlated.sched_time},{apc_correlated.close_date_time} ) < 0 then "Early" else If...
  9. capronton

    Suppress records where log.scheduleTime = trip.endTime

    Thanks all for you feedback. I apologize for not responding sooner. I was able to solve the problem by putting the code below in the "Section Expert" suppress formula. Time({incident_log.sched_time}) = Time({trip.end_time}) Thanks again.
  10. capronton

    Suppress records where log.scheduleTime = trip.endTime

    I would like to suppress records in two different tables. I put the code below in "detail section expert" and it is not working. Can someone assist? {incident_log.sched_time} = {trip.end_time}
  11. capronton

    Left Outer Join Syntax error

    Since I was trying to join "tr" to another table other than "ppd" (i.e., table "et") than I had to change the statement below to a "RIGHT OUTER JOIN" and this seems to be working okay. See the working statement below. Thanks for all your help with this. "RIGHT JOIN et ON et.type = tr.type
  12. capronton

    Left Outer Join Syntax error

    Thanks for your help. The LEFT OUTER JOIN is working, however the statement "LEFT JOIN tr ON et tr.type = et.type" is giving me the error below. How would I LEFT OUTER JOIN table "tr.type" to "et.type"? [SQL]: select...
  13. capronton

    Left Outer Join Syntax error

    Basically, I'm trying to pull all records in the "tr" table even though they have no corresponding row in the other tables.
  14. capronton

    Left Outer Join Syntax error

    Can someone explain why the query below is getting the syntax error below? How could I re-write this query to do a LEFT OUTER JOIN on the fields/columns below? [SQL]: select ts,tr.type,et.text,tr.n,tr.loc_n,bus,drv,run,route,ttp,grp,des,seq,tpbc,longitude,latitude,tr.fs,amt FROM tr LEFT OUTER...
  15. capronton

    How to join Excel Spreadsheet table &quot;Date&quot; field to MS SQL Server &quot;Date&quot; field

    Got the statement below to work. Thanks. time({Command.start_time}) = time(7,0,0)
  16. capronton

    How to join Excel Spreadsheet table &quot;Date&quot; field to MS SQL Server &quot;Date&quot; field

    The statements below also give me an error. {Command.start_time} = timeserial(7,0,0) {Command.start_time} = timeserial(8,12,0)
  17. capronton

    How to join Excel Spreadsheet table &quot;Date&quot; field to MS SQL Server &quot;Date&quot; field

    Skip, instead of using Excel to try to pull in "schHdwyTrapeze" then I hard-coded the value in the formula below. However in the statement below the {Command.start_time} = datetime("7:00AM") is not working. If {Command.block_id} = 803006 and {Command.direction_code_id} = 4 and...
  18. capronton

    How to join Excel Spreadsheet table &quot;Date&quot; field to MS SQL Server &quot;Date&quot; field

    This is the "startTrip" Date join. The report will not run when I add the join below. EXTERNAL JOIN schdHeadway_Trapeze_.startTrip={?cmtaocltdb: Command.start_time}

Part and Inventory Search

Back
Top