How to assign value to user table field of type time

[Former Member]

Hi,

In this line of code

oUserTable.UserFields.Fields.Item("U_SBTime").Value = oDBs_Detail.GetValue("U_SBTime", i)

i am assigning value to user table field of datetime,but it is taking always 12:00 why?

here ia m updating table so, 0:00 is storing in tables

[YatseaLi]

Time type in B1 only takes the hour and minits only with format: HH:MM

Date type in B1 only takes the year, month date 2009-05-26 00:00:00

That is why always 0.00 stored in DB.

You can get the exact current time the following query. like: 11:45

SELECT Left(Convert(varchar,GetDate(),8),5)

Kind Regards, Yatsea

[Former Member]

Hi,

Thank U for u r reply,

Here iam giving time not date(eg break time ,lunch time)

i entered 12:35 , 11:45

next i want to update this timings like

this

oUserTable.UserFields.Fields.Item("U_SRTime").Value = oDBs_Detail.GetValue("U_SRTime", i)

here i am getting the problem

[YatseaLi]

Hi,

Please post the contextual code for analysis.

The problem may be oDBs_Detail.GetValue("U_SRTime", i) ,

the value is not got in the right format or not retrieved at all.

Regards, Yatsea

[Former Member]

Hi,

oDBs_Detail.GetValue("U_SRTime", i) here i am getting correct value but assing to oUserTable.UserFields.Fields.Item("U_SRTime").Value this is creating problem it is taking 0:00 value

Regards Uday