Time Math -- Easy in SQL what about in Aware?

BLOMASKY

I have 2 attributes, Pickup and Arrival. Both are timestamp fields. They have BOTH been computed previously. For example, pickup 9:00 AM, arrival 9:45AM. Now the user wants to enter a new pickup time and I need to change the arrival time by the DELTA of the original pickup time and the new one. So if they enter, 9:20 pickup time, I need to add 20 minutes to the arrival.

Not sure how to code that in aware

Bruce

BobK

Out of curiosity, how would you do that in SQL?

joben

Here is one idea that I tested, and it works:

First create a duration attribute called duration.

Activate this update rule:

If BO.Pickup WAS CHANGED AND NOT(BO IS NEW) Then
BO.duration=BO.Pickup-OLD_VALUE(BO.Pickup)
BO.Arrival=BO.Arrival+BO.duration

Set it to:
Dynamic
Do not run on server
Form initialization: No

Came up with this in a few minutes so it might need some improvements.

BLOMASKY

BobK wrote
Out of curiosity, how would you do that in SQL?

Update BO set Arrival = DateADD(mi, dateDiff(mi, oldPickup, pickup), Arrival)

Bruce

aware_support

Adding to a timestamp gives you another timestamp. Adding 1 means adding 1 hour. Adding 0.5 means adding 30 min.

BobK

BLOMASKY wrote
BobK wrote
Out of curiosity, how would you do that in SQL?

Update BO set Arrival = DateADD(mi, dateDiff(mi, oldPickup, pickup), Arrival)

Bruce

Thanks