Here is my successful test of this. Plus I am able to load these datetime
variables into my table so I know this will all work.
My test program:
SET VAR vKeepTime = (CVAL("time format"))
SET TIME FORMAT HH:MM
SET VAR vDateTime1 DATETIME = (DATETIME( "10/16/2012", .#time))
SET VAR vDateTime2 DATETIME = .#NOW
SET VAR vSeconds INTEGER = (.vDateTime2 - .vDateTime1)
SET VAR vMinutes DOUBLE = (.vSeconds / 60)
SET VAR vHours DOUBLE = (.vMinutes / 60)
SHOW VAR
SET TIME FORMAT &vKeepTime
Here's the resulting variable list:
vDateTime1 = 10/16/12 12:58 DATETIME
vDateTime2 = 10/17/12 12:58 DATETIME
vSeconds = 86390 INTEGER
vMinutes = 1439.83333333333 DOUBLE
vHours = 23.9972222222222 DOUBLE
Thanks for the interesting discussion!
Karen
