Re: OB Get on Time Field

2017-05-26 Thread info--- via 4D_Tech
> I suppose I'm missing something obvious... > > Within an object "created":"2014-02-01T09:28:56" > > OB Get is returning the correct date with: > > OB Get($OBGenInfo;"created";Is date) with > > But, time always returns ?00:00:02? using: > > OB Get($OBGenInfo;"created";Is time) > > Or is the time

Re: OB Get on Time Field

2017-05-25 Thread Keisuke Miyako via 4D_Tech
OB Get is simply doing the reverse of OB SET, which sets milliseconds for time. If you want to convert an ISO GMT timestamp to 4D local date or time you can use the Date and Time commands, which were upgraded in v14: $timestamp:="2017-05-25T23:00:00.294Z" //next day in Japan

Re: OB Get on Time Field

2017-05-24 Thread Keisuke Miyako via 4D_Tech
the same question was posted on the forums a couple of days ago. time values are represented in milliseconds, so a date string, the first part of which is the year 2017, approximates to 2 seconds past midnight. > 2017/05/25 8:32、Tom Dillon via 4D_Tech <4d_tech@lists.4d.com> のメール: > > OB

OB Get on Time Field

2017-05-24 Thread Tom Dillon via 4D_Tech
I suppose I'm missing something obvious... Within an object "created":"2014-02-01T09:28:56" OB Get is returning the correct date with: OB Get($OBGenInfo;"created";Is date) with But, time always returns ?00:00:02? using: OB Get($OBGenInfo;"created";Is time) Or is the time a count down 'till