no worries
Oh , He's me mate and I owe him
(Sorry Karen we spell and talk different) At 05:09 PM 2003-09-17 +1000, you wrote:
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
Tony Luck
Brisbane Australia
