Recent content by weathergirl

I would have put it in the Lead Time field under arrive. I may have taken it out because it didn't work, but that's where I had it. I just copied and pasted it in. WG

There aren't any differences between the your and mine. Does it have to do with were I put the script in the form? WG

I copied it into a new script and ran it. I tried a couple times and it worked. WG

What script do you want? Any script associated with the form should be in that file. WG

The Windows Time is set to the format 1:20:00 PM. I don't know how it would have changed if it did. WG

I copied it straight from the board. Would it still be something to do with the format of the string? Weather Girl

I inserted it into a new blank script and it does the same thing. I changed the minutes field to a number and I still get the longInt. Weather Girl

I think I changed everything to the same time format. When I use the format I have everything in it gives me all the data like I didn't even enter any search parameters. Weather Girl

I'm still having problems with the format. The query works when I use HH:mm:ss but it comes up with no data even when there should be. Is it not able to read the times because of the different formats? Weather Girl

It didn't work sorry to say. The view box of the number comes up with a "default" value that appeared the 1st time I used it, but it never changes. Then it inserts a number like 599940 when there's a difference of twenty-five minutes. I tried changing a couple things but that only...

I put in 5:40 PM for the start time and 5:50 PM for the end time. In the tot minutes it calculates 12:09:59. It seems to not round up the seconds and I don't need the hours or the seconds on there. Just the number of minutes. Weather Girl

I found that using HH:MM:SS works to run the query manually. I tried adding the AM or PM but then it gave me an error of missing comma. So I need to add the :ss to the string, but how do I do that? And what do I do with the AM and PM part? Weather Girl

I found that using HH:MM:SS works to run the query manually. I tried adding the AM or PM but then it gave me an error of missing comma. So I need to add the :ss to the string, but how do I do that? Weather Girl

It gives the correct minutes, but when I tried dividing the number was much further off. I also tried inserting the formatStringAsTime() but it gives me a syntax error when I do that. Weather Girl

Mac, This script works to a certain extent. The subtracted value is put into the tot_minutes field but it doesn't subtract the hours. I don't know if it's the format of the fields; they are all in the same format of 3:30 PM. I already have a field that does the calculation by using the field...