i have two fields that are varchar in the db that hold the time - in format hh:mm a or p
i am trying to calculate the difference between them with something like
datediff("n",CTime({Command.timeout}),Time({Command.timein}));
but i keep getting getting an error on the first portion.
I can convert using CTime and it prints out the correct time like so... but can't figure out how to use these variables in a calulation
local Timevar Out :=CTime({Command.timeout});
local TimeVar tin :=CTime({Command.timein});