Search results for query: *

Hahahahaha.. you are on spot! I was just lazy now and I did (rounddown(datediff)-1)*5. 🤣 If I have time, I will for sure go back and adjust it with the charge table.

As soon as I plugged " /60" to my query with datediff in seconds, it would beautifully. Thank you so much for your help!

Thank you! But how do you round down 15 minutes increments for datediff in seconds?

That is correct. But the problem is, that it's rounding down to 00:45, which in the fact, I would need that to be 00:30.

I think I figured out the second part. If you have any advice for the first part I would appreciate it. I known it's because I'm taking "minutes" so it's taking 30-45 (ok instead of including seconds in it).

So in excel I would use =rounddown(datediff field * 96,0)/96 . That would give me rounddown for nearest 15 minutes Then I would use formula =rounddown(datediff field * 96,0) -1. That would give me how many 15 minutes is above first 30 minutes. I would then multiple it by my 5. How can I...

It didn't work. Still showing 45. My datetime A is 12:45:49. Datetime B is 13:30:07. The difference is 00:44:18. I would need it to round down to 00:30:00. Do you have any advice for part two? Thank you so much for your time helping me!

I'm sorry. Anything over 30 minutes starts with 5 for every 15 minutes.

That's exactly how I did it.

Hi. I'm working on a query in SQL. I have datetime A and datetime B. I calculated the time difference between them. And now the fun part starts. I need to round down the time difference to every 15 minutes. I partially figured out the round down part, except, it's rounding minutes in the time...

You are correct on the only time() function. Thank you very much for your help (as always!). I actually made it work and it works perfectly. :)

Thank you so much! I'm getting correct time stamp for the address. However, I'm now getting the latest time stamp (for either field_name- not necessarily just for the problem) for the ProbDT formula (please, see the attachment). Ultimately, I need to calculate 1. fixed time (a fixed field from...

thank you very much! I see the logic behind it and it make sense and I think it might work! I'm using a group based on an incident ID. Is it too much to ask how the reset formula would look like? Or do I do running total field?

Thank you lbass, I was hoping that you would answer. You've always helped me in the past. The problem is, that my first formula- {@MIN_Problem} is giving me blank value for the address, so my second formula- {@LessThanMINProblem}- has "YES" value for every address. And my third formula is...

Good afternoon, I kinda got stuck writing a report In Crystal report 2008. I have a database with several time stamps for several kategories (names). I'm only looking for Address and Problem Category (which I'm filtering). I'm trying to get a time stamp for the first problem and the time stamp...

Thank you very much for all your suggestions!

Thank you! This is actually going to work.. I just write a formula: Latitude: =C2/1000000 Longitude: =-(C2/1000000) It's so simple.. Why didn't I think about that? :) Thank you again!

I need the Lat and Long where it is a 2 digit whole number then decimal and the rest of the numbers. I know there is a term for this type of lat/long format, but I couldn't remember it. Currently Lat Long comes from the database as one number, for example 12345678 and I need that to be...