Convert string (time string ) to time format

[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

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

[Former Member]

HI,

Di you defined your User defined field at the table as Date and subtype as time?

For me Working well in PL49 B12007

oudf.Type = BoFieldTypes.db_Date 
oudf.SubType = BoFldSubTypes.st_Time 

Regards,

J.