End of year as default value in date item [SOLVED]
509086Feb 5 2008 — edited Feb 5 2008Hi
I'd like the last day of the current year (i.e. 31.12.2008) to be the default value of an item (in Forms 6i) (Format dd.mm.rrrr).
The default value in the database is
TO_DATE('31.12.'||TO_CHAR(sysdate,'yyyy')) and there it works fine.
In Forms I have a WHEN-CREATE-RECORD Trigger with:
my_item := TO_DATE('31.12.'||TO_CHAR(sysdate,'yyyy'));
(generated from Designer)
However, whatwever I write there I always get some "crap" in the form, most of the time 20.12.0031.
I can see that it has something to do with the language settings, but don't know where to make some changes.
Can anybody help my on this, I am aware, trivial matter.
Thanks
Karine
Message was edited by:
kpa