Re: database_value problem

<zajcREMOVE_at_gmx.li> wrote in message news:<9opnhd$fgn$1_at_planja.arnes.si>...
> Hello!
>
> I'm having problem with database_value syntax in the following statement in
> Developer 6:
>
> if :SYSTEM.CURSOR_VALUE > sysdate then
> copy
> (TO_DATE(GET_ITEM_PROPERTY(:SYSTEM.CURRENT_ITEM,Database_value),'DD-MON-RR')
> ,:SYSTEM_CURRENT_ITEM;
> end if;
>
> For example: if I have a date field 12/12/91, which I change into 02/02/02.
> Because the date is higher then sysdate it gets database value but instead
> 12/12/91 (12/12/1991) I get 12/12/2091.
>
> I really don't know how to solve the problem.
>
> Thanks in advance, Boris
>

Boris, you appear to be working in FORMS so you might get a better response on the tools board but here are two things you can check:

1- have you verified that the database value was not stored as 20**? 2- With forms45 we had to set a couple of environmental variables to handle dates the way we wanted:  

FORMS45_USER_DATETIME_FORMAT=DD-MON-RR HH24:MI:SS
FORMS45_ERROR_DATETIME_FORMAT=DD-MON-RR HH24:MI:SS
FORMS45_OUTPUT_DATE_FORMAT=DD-MON-RR

FORMS45_ERROR_DATE_FORMAT=DD-MON-RR
FORMS45_USER_DATE_FORMAT=DD-MON-RR
FORMS45_OUTPUT_DATETIME_FORMAT=DD-MON-RR HH24:MI:SS

I do not believe we are setting anything for version 6 but you did not list your version.

3- Check the get_item_property documentation to see if it has any date handling options.

Good luck.

• Mark D Powell --