1) you need to do a recalc variables after the field is changed using an epp on the field, the row, or with an update button.
now if you do the recalc your vtime that you changed will be recalced and will go back to the original value because of the order of your variables
2) so add a variable on the form NewTime data type Time
change zVisitInDt=(DATETIME(.vservice_date,.newtime))
if you want the value loaded into newtime use an epp on row entry
hope this helps GARY
At 05:09 PM 9/17/2003 +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
