Support Forum

Ask questions and get help from MobileTogether experts.
MobileTogether Product Information
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
jwatt222  
#1 Posted : Monday, May 23, 2016 7:28:48 PM(UTC)
jwatt222

Rank: Advanced Member

Groups: Registered
Joined: 5/23/2016(UTC)
Posts: 91
United States
Location: Virginia

Thanks: 14 times
I am new to mobile designer but have built my solution in a short time. However, I have been stuck for a few days now on completing my app because I cannot seem to calculate a datetime that is the critical value in building my app in the first place. All of the calculations in my app work except where I want to add and subtract time.

In the help file I have found that this works only if I personally put in the date and the number of hours manually:

add-hours-to-dateTime(xs:dateTime("2014-01-15T13:00:00"), 10) However,

I want the app to pull the time from the solution and to add or subtract the hours. For example want to pull a dateTime from one of my forms and subtract a number of hours that has already been determined by the solution.

How do I convert the node to the actual parameters as in the above function? For example:
$PERSISTENT/Root/CurrentLoad/PastLoads/ShippersAppt - ($PERSISTENT/Root/CurrentLoad/PastLoads/HourstoPickup div 24)

Thanks


bbv  
#2 Posted : Tuesday, May 24, 2016 9:25:59 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 363

Was thanked: 59 time(s) in 59 post(s)
Everything seems to work just fine if I do exactly what you have been trying to do.

I've used this statement:
Code:
add-hours-to-dateTime( $PERSISTENT/Root/CurrentLoad/PastLoads/ShippersApt, $PERSISTENT/Root/CurrentLoad/PastLoads/HourstoPickup )


with a tree which contains your values (see the screenshot)
bbv attached the following image(s):
Capture.PNG
jwatt222  
#3 Posted : Tuesday, May 24, 2016 5:00:24 PM(UTC)
jwatt222

Rank: Advanced Member

Groups: Registered
Joined: 5/23/2016(UTC)
Posts: 91
United States
Location: Virginia

Thanks: 14 times
Thanks for the help. However, what you have is not the same as I am trying to do. You have added the hours to the date but for some reason this isn't working for me either. When in simulation mode the StartbyDateTime is not being picked up in the persistent tree and the error message says that no target node was found. However, when I check for it under the persistent tree in design mode it is there. Not sure what's going on there.

What I'm trying to accomplish:
I am building an app for truckers. What I am trying to do here is to subtract the hours required to get to the pickup + 1.5 hours (equipment prep time)from the pickup datetime. This will determine a startbydatetime the trucker must leave in order to reach the pickup on time. From there I will determine the ETA to delivery and his next available time. I am stuck because I can't get the startbydatetime.

Much help appreciated.
Thanks.
jwatt222  
#4 Posted : Tuesday, May 24, 2016 5:15:04 PM(UTC)
jwatt222

Rank: Advanced Member

Groups: Registered
Joined: 5/23/2016(UTC)
Posts: 91
United States
Location: Virginia

Thanks: 14 times
Also, I noticed that you have the date and the 10 hours in your tree already set to display when loaded.

I am using a calculation to determine what the hours to pickup are and this is working fine. The hours are appearing in the form. The calculation is (miles to pick up div average speed).

The pickup time is given in the dispatch so it would be a known value.

The 1.5 is a constant used to show time for inspections, fueling, etc.

If I do this on my database in MSaccess the formular StartbyDateTime = ShippersAppt - (HourstoPickup + 1.5)/24 works perfectly. However it does not work in mobile designer. If I pull it from the database to the form then an error occurs when I try to update the form.

Thanks,
bbv  
#5 Posted : Wednesday, May 25, 2016 11:50:09 AM(UTC)
bbv

Rank: Administration

Groups: Registered, Administrators
Joined: 7/21/2014(UTC)
Posts: 363

Was thanked: 59 time(s) in 59 post(s)
I could give you an exact formula you need, if you would simply show here the tree with your actual data as it comes from the database. So far I have to guess a lot.

For your understanding, you can supply only integer numbers to the add-...-to-dateTime function for addition or subtraction. XPath is a strictly typed language which avoids a lot of accidential errors, but requires sometimes explicit type conversion. Because you need to add 1.5 hours, you will have to switch calculation to minutes.

The new formula I'm using is
Code:
add-minutes-to-dateTime(
    $PERSISTENT/Root/CurrentLoad/PastLoads/ShippersApt,
    - xs:integer( ( $PERSISTENT/Root/CurrentLoad/PastLoads/HourstoPickup + 1.5 ) * 60 )
)


I'm adding to HourstoPickup 1.5 hours, multiplying it by 60 and enclosing the result in xs:integer to calculate in exact minutes. With - before xs:integer I achieve subtraction.
jwatt222  
#6 Posted : Wednesday, May 25, 2016 6:45:29 PM(UTC)
jwatt222

Rank: Advanced Member

Groups: Registered
Joined: 5/23/2016(UTC)
Posts: 91
United States
Location: Virginia

Thanks: 14 times
Thanks a million! This did the trick. Everything is working fine and I am nearing the completion of my app. I have been working on it for over a year and have tried several different solutions which could not do what you just did. Built it with Mobil Designer in about five days with your help. Can't say thank you enough.
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.