Hi,
I convert a date value (from database) to ticks value and assign to a variable.
I can see the date in the table use in the "cmd.ExecuteTable" statement, but the variable shows zero (0) value after conversion. the code is like :
cmd.CommandText="select dob from member where perm_pid= "&tt&""
cmd.ExecuteTable("table12",0)
mm=DateParse(table12.Cell("dob",0))
Msgbox("dob :"&mm) ; shows dob : 0
Please correct me.
regards,
I convert a date value (from database) to ticks value and assign to a variable.
I can see the date in the table use in the "cmd.ExecuteTable" statement, but the variable shows zero (0) value after conversion. the code is like :
cmd.CommandText="select dob from member where perm_pid= "&tt&""
cmd.ExecuteTable("table12",0)
mm=DateParse(table12.Cell("dob",0))
Msgbox("dob :"&mm) ; shows dob : 0
Please correct me.
regards,