I have two fields in a record
RespStart and RespEnd in a DateTime format...

When I type in 01:AM and 01:05AM into each field respectavley.. the values change to 01:01:00AM and 01:05:00AM

I am trying to grab the total time from Start to End. When I query the table I get this format in the View

RespStart = 1899-12-30 01:01:00.000
RespEnd = 1899-12-30 01:05:00.000

(RespEnd-RespStart) = 1900-01-01 00:00:00.000


Is there a format to grab the Time values and get the difference from that and / or also change the date field to the current date if needed but mainly I want to get the time format to get the time between
RespStart and RespEnd


Thank you,

--the first two SQL are test to see the values put out
(Select RespStart From TBLBAT_ALARMINC Where AlarmTypeID = 1 AND BatchID = m.BatchID AND ModemID = a.ModemID) AS RespStart,

(Select RespEnd From TBLBAT_ALARMINC Where AlarmTypeID = 1 AND BatchID = m.BatchID AND ModemID = a.ModemID) AS RespEnd,


--This should be the value to grab the time used
(Select (RespEnd - RespEnd) From TBLBAT_ALARMINC Where AlarmTypeID = 1 AND BatchID = m.BatchID AND ModemID = a.ModemID) AS RespTime