Comparing my Table Date, Time fields with System Date&Time.
Posted on 2002-07-25
My Dbase Table have fields 'ST_TIME' Character (10) for Time and 'ST_DATE' Date(8) field for Date. I am using these field to save System Input Time and Date from my application.
I have a calculation in my logic to compare this table 'ST_DATE, 'ST_TIME' with the system present Date&Time. If the difference is more than 48 hours I have some logic to do(like closing the record).
So how can I compare that table 'ST_DATE', 'ST_TIME' with system present Date&Time to find 48 hours difference.
My Table is saving time like :- 11:56:32PM
date like :- 25/07/2002
Please help me to calculate/compare 48 hours time difference. For ex.if do
(Table.FieldByName('ST_TIME').AsSting - TimetoStr(Time)).
I am getting errors. Please tell me the way to do this.