Help Please

 I have a table with a datetime variable and only which to display the time.

 Firstly is there a mask I can use , I could not find one.

 So I thought of another approach

 The date time column is called visitInDT

 So I put a variable variable on the form vTime=(TEXTRACT(visitInDt))
 I can extract the date part using vService_date-(DExtraxct(visitInDt))


 This extract the time and date.I check the variables have the contents
 expected so the extract works.


 I place the vtime variable on the form and make it editable.

 So I can now edit the time, looking like a time varaible.
 I then try to update the datetime column by
 using variable zVisitInDt=(DATETIME(.vservice_date,.vtime)) this date time
variable has  recombined okay. The varaible zVisitInDt has the new time.
Then try to make the Column take the contents of the variable.

using  VisitInDt=.zVisitInDt

and this does not work it reverts back the original time.

What am I doing wrong ?

Victor

Reply via email to