Re: Problem calculating differences

Do you have to do the %diff in microseconds only? Can you do it in two steps?

c wDays = %diff(DateTime2: DateTime1: *days)
c NewDateTime2 = DateTime2 - %days(wDays)
c wMSec = (wDays * 24 * 60 * 60 * 1000) + %diff((NewDateTime2: DateTime1: *MSecs)

That isn't tested, but you see the idea? Would that work for you, Joe?

.


Joe Pluta wrote:

Joe Pluta wrote:

I'm trying to interoperate with Java timestamps. In the Java world, that's the number of milliseconds since 01/01/1970. This is a web service, and the service was defined using the Java timestamp format. I can change the service signature to use something different, but I was trying to avoid that.

What REALLY sucks about this is that I wrote three services in 30 minutes. It has now taken me two hours to isolaet and try to find a workaround to the arbitrary 15-digit limitation in %DIFF. All the time I talk about how productive RPG is, and this has really bitten me in the butt. The fact that there is no "milliseconds" parameter to %DIFF, and then it fails if you use it for large numbers - that's just a bad deal. If there were no limitation, or if there were a milliseconds parameter, I'd have been done hours ago.

Joe