As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
I am trying to write an if statement with 2 conditions.... one of them being if it has been longer than 60 minutes and the other condition is that it is "late". Example, I am trying to determine when shipments are late over an hour but I don't want it to count when shipments are early, just when they are late. Here is the equation I had originally buts its counting when shipments are greater than 60 minutes early as well:
IF HDIFF ( SHIPMENT_INDIVIDUAL_MOVE_COSTING.LOAD_DATE_FIELDS.SL_LD_DROP_ACTUAL_DATE , SHIPMENT_INDIVIDUAL_MOVE_COSTING.LOAD_DATE_FIELDS.SL_LD_DROP_APPT_START_DATE , 'Minute' , 'D6' ) GT 60 THEN 1 ELSE 0
Any assistance or thoughts are appreciated.... I feel stuckThis message has been edited. Last edited by: FP Mod Chuck,
Your Function is OK, although I would use the simplified DTDIFF(SL_LD_DROP_ACTUAL_DATE , SL_LD_DROP_APPT_START_DATE , MINUTE) instead to optimize SQL. 60 min early would be -60 so that wouldn't pass your GT 60 condition.
This is part of a define. I am currently not detecting early from late in another field. I can physically look and see if something is early or late from the dates shown but I do not have an equation setup (other than the one I wrote above) that detects early vs late.
Originally posted by Frans: Your Function is OK, although I would use the simplified DTDIFF(SL_LD_DROP_ACTUAL_DATE , SL_LD_DROP_APPT_START_DATE , MINUTE) instead to optimize SQL. 60 min early would be -60 so that wouldn't pass your GT 60 condition.