Hi friends,
I have a database item called start_time with data type date and this is non displayed item in form. There is another item called st_time (which is not database item) which take the value from start_time in hh24: mi format(st_time = start_time), data type is datetime and this is displayed item.
I am having a problem when I am trying to change the st_time hh24:mi value. Suppose when I open my form at that time start_time value is 14/09/2003 9:30 and st_time is 9:30. Now, suppose I want to change start_time to 14/09/2003 8:20. It workers fine for hh24:mi but instead of keeping date as 14/09/2003 it changes date value to 1/09/2003. Can anyone tell me why is it happening and how can I rectify it?
Thanks in advance,
Anju
I have a database item called start_time with data type date and this is non displayed item in form. There is another item called st_time (which is not database item) which take the value from start_time in hh24: mi format(st_time = start_time), data type is datetime and this is displayed item.
I am having a problem when I am trying to change the st_time hh24:mi value. Suppose when I open my form at that time start_time value is 14/09/2003 9:30 and st_time is 9:30. Now, suppose I want to change start_time to 14/09/2003 8:20. It workers fine for hh24:mi but instead of keeping date as 14/09/2003 it changes date value to 1/09/2003. Can anyone tell me why is it happening and how can I rectify it?
Thanks in advance,
Anju