Hi LJ - I'll try that with the form exports - but interestingly, I've found one copy on a server with history and the data in that field changed after the migration to 9.1 - on 7.6.04 it was just a regular time stamp in a text field, after the upgrade it became a UNIX date integer stored in a text field.
On 2 May 2017 at 15:43, LJ LongWing <[email protected]> wrote: > ** > Dave, maybe a copy of logs of the workflow or something...maybe a copy on > a server that's not working, but working in a copy of the form...screen > shots of the workflow in question...but if it's a default...there is no > workflow.... > > try this....export two copies of the form...one that's working, the other > that's not, from the same server...export both in XML format, compare and > contrast the properties of that field, and the form in general...see if you > can find some difference... > > On Tue, May 2, 2017 at 6:20 AM, Dave Barber <[email protected]> > wrote: > >> ** >> All, >> >> We have a form, used as part of a notifications system, it has a 255 >> character field with a default value as $TIMESTAMP$. So in theory it >> should store a value 02/05/2017 08:13:40 (UK/GMT date format) >> >> We've recently gone through a series of upgrades, from Remedy 7.6.04 (on >> Solaris) to 9.1.02 (RHL). All of our old test environments bar one have >> gone through an upgrade from 7.6.04 to 9.1.02 - and we have a range of >> dev/test environments that have always been on 9.1.02, with a copy of the >> database from one of the older environments. >> >> "Bar one" is an important point - the only remaining 7.6.04 system is >> happily working as expected. Every other system is storing the date in >> this field in UNIX format (ie. 1493712820). >> >> I cannot figure out why this is happening - I've made a copy of the form, >> it behaves as expected. I've created a new form and set $TIMESTAMP$ - >> works as expected. But on this one form it isn't .... some strange >> form/field corruption? >> >> Any suggestions as to a way forward with this? >> >> Regards >> >> Dave >> _ARSlist: "Where the Answers Are" and have been for 20 years_ > > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
