HTML DB 2.0 and SYSDATE formatting problem
474742Jan 11 2006 — edited Jan 16 2006Couldn't find a thread on this so here goes:
In the former versions of HTML DB, when I defaulted a text field, or date picker to SYSDATE, I would get the date in the format I asked for, namely 12-MAY-2005
Now, when I deault to SYSDATE, I get 12-MAY-05. Problem I noticed also was that if I made the field a datepicker and defaulted to DD-MMM-YYYY SYSDATE, I still get the 12-MAY-05 and when I hit the picker, the date in the calendar defaults to Jan 1920....
WHAT is up with this??????? Anyone?? Thanx