• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Comparing my Table Date, Time fields with System Date&Time.

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.
0
VENKAT
Asked:
VENKAT
  • 6
  • 5
1 Solution
 
kretzschmarCommented:
try

if time-strtotime(Table.FieldByName('ST_TIME').AsSting) > 2 then ...

but attention
your apptimeformat or systemtimeformat must
be set to this format

11:56:32PM

meikl ;-)
0
 
kretzschmarCommented:
oops something missed->ST_Date

replace this

if time-strtotime(Table.FieldByName('ST_TIME').AsSting) > 2 then ...

with

if now-(
   Trunc(strtodate(Table.FieldByName('ST_DATE').AsSting))+  
   Frac(strtotime(Table.FieldByName('ST_TIME').AsSting))
   ) > 2 then ...

just from head, not tested

meikl ;-)
0
 
kretzschmarCommented:
but attention
your apptimeformat or systemtimeformat and
your appdateformat or systemdateformat
must be set to your format

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
VENKATAuthor Commented:
hi kretzschmar
       thank u. But How can I check with my Date and Time both with present Date and Time to get 48 hours difference.
0
 
VENKATAuthor Commented:
hi kretzschmar
       thank u. But How can I check with my Date and Time both with present Date and Time to get 48 hours difference.
0
 
kretzschmarCommented:
now() gives you the current-datetime,
see above, the if statement does all for you

one day is represented by 1

meikl ;-)
0
 
VENKATAuthor Commented:
hi kretzschmar
       thank u. But How can I check with my Date and Time both with present Date and Time to get 48 hours difference.
0
 
VENKATAuthor Commented:
sorry I think my page was refresh..i will check first.
0
 
VENKATAuthor Commented:
I used like this...my ST_DATE is date field which have date like 25/07/2002.
        if now - (
          Trunc(TimeTable.FieldByName('ST_DATE').AsDateTime)+
          Frac(strtotime(TimeTable.FieldByName('ST_TIME').AsString))
          ) > 2 then
...Now I am getting error like 25/07/2002 is not valid DateTime.
0
 
kretzschmarCommented:
well,
your system-shortdateformat seems
to be other than dd/mm/yyyy

at appstart (for ex. in the create-event of your mainform)
set the dateformat appwide with

shortdateformat := 'dd/mm/yyyy';
dateseparator := '/';

meikl ;-)
0
 
VENKATAuthor Commented:
thank u..success.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now