Hi The DB2 field is a "Date", the Remedy Vendor form is marked as "Date", and there is a conversion method in the plugin we developed - but it never gets that far - it's the AR server coming with the error, not the plugin or the database. I think I'll try setting a "0" in the field, since it tells me that the limit is 0-0, and see what happens.
/Jonas -----Oprindelig meddelelse----- Fra: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] På vegne af Jarl Grøneng Sendt: 25. august 2009 17:40 Til: arslist@ARSLIST.ORG Emne: Re: Field limits and date only fields Hi, Have you tried to "convert" the date to the server date format? The fieldtype in the plugin, it that a date or date-time field? -- Jarl 2009/8/25 Jonas Stumph Stevnsvig <jonas.stumph.stevns...@bec.dk>: > Hi again > > Same behaviour, both with setting the value in an integer field first, and in > a filter. The think that's puzzling me is that the error doesn't seem to come > from the API, but from the AR system itself. > > > > Med venlig hilsen > > Jonas Stumph Stevnsvig > Remedy Udvikler > BEC Kompetence Centret > Telefon (+45) 46 38 20 08 > Mobil (+45) 61 56 20 08 > jonas.stumph.stevns...@bec.dk > > Til remedy spørgsmål: becrem...@bec.dk > > BEC - det fælles it-hus, der gør forskellen for finansielle > virksomheder > > -----Oprindelig meddelelse----- > Fra: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] På vegne af Jarl Grøneng > Sendt: 22. august 2009 20:12 > Til: arslist@ARSLIST.ORG > Emne: Re: Field limits and date only fields > > Hi, > > Do you get a diffrent behviour if you do the same operation in a filter? > > -- > Jarl > > > > 2009/8/20 Jonas Stumph Stevnsvig <jonas.stumph.stevns...@bec.dk>: >> ** >> Hi guys, (is it going to be "Jarl to the rescue" again :-D) >> >> I have a weird bahviour in a vendor form: >> >> I have a Date field, which fails when a date is pushed to it by an >> active link. The value is taken from a Date/Time field and run >> through the >> DATE($mydatetimefield$) function. >> >> the error: >> >> "ARERR [306] Value does not fall within the limits specified for the >> field >> : (0 - 0) : 536870922" >> >> >> from the log: >> "<ACTL> (536870922) = 24. august 2009" >> >> as far as I can tell the date field limit is defined by the >> DateOnlyFieldLimit(); method in Java, and I can't see any >> restrictions in the database section of the field properties - so i >> guess the 0 - 0 is a wild goose chase. >> >> I've had some other bothers with regional settings - is that whats >> bothering me here to? shouldn't the value be "24-08-2009" and in that >> case, how to I get my active link to format the date properly? >> >> >> thanks in advance, >> ARS 7...@w2k3 >> >> Jonas Stumph Stevnsvig >> Remedy Developer >> BEC Competence Centre >> Phone (+45) 46 38 20 08 >> Mobile (+45) 61 56 20 08 >> jonas.stumph.stevns...@bec.dk >> becrem...@bec.dk >> >> _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the >> Answers Are"_ > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ______________________________________________________________________ > _________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"