Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How to do date math on calculated fields Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
28-Aug-02
Category
Algorithm
Language
Delphi All Versions
Views
138
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			Author: Tomas Rutkauskas

How to do date math on calculated fields

Answer:

When doing date math on calculated fields, it is important to ensure that all 
values being used are properly matched as to type. The double method (not in the 
docs) casts the value to a useable type. In the following method, d1 and d2 (part 
of table1) can be of either date or dateTime type and d3 is an integer field.

1   procedure TForm1.Table1CalcFields(DataSet: TDataset);
2   var
3     t1, t2: TDateTime;
4   begin
5     table1d1.asDateTime := Date + 2; {or table1d1.value := date + 2;}
6     table1d2.asDateTime := Date - 2;
7     t1 := table1d1.asDateTime;
8     t2 := table1d2.asDateTime;
9     table1d3.asInteger := trunc(double(t1) - double(t2));
10  end;


			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC