CSGPC
asked on
Date Manipulation
How do I calculate the number of days between the current date and a date field.
I am using Delphi 3 with QuickReport 2.0g
I am using Delphi 3 with QuickReport 2.0g
ASKER
This is how you would do it in Delphi. I need to manipulate QuickReport to produce the anwers. (Currently the report produces a label instead of the number of days.)
When you use DecodeDate Days will be in 1..DaysInMonth (DaysInMonth = 28, 29, 30 or 31)
not the number of days between the two.
You do not need call DecodeDate.
The integral part of a Dif value is the number of days between two.
(see help on TDateTime).
I found two ways how to PRINT
the number of days between the current date and a date field.
1) Create calculated field DifDate (Integer or Float)
and write OnCalcFields handler as
procedure TForm1.Table1CalcFields(Da taSet: TDataSet);
begin
Table1DifDate.AsFloat := Now - Table1SaleDate.AsDateTime;
end;
set QRDBText component into report and set property DataField = DifDate
2) set QRLabel component into report
and write OnPrint handler as
procedure TForm1.QRLabel1Print(sende r: TObject; var Value: String);
begin
Value := FloatToStr(Now - Table1SaleDate.AsDateTime) ;
end;
not the number of days between the two.
You do not need call DecodeDate.
The integral part of a Dif value is the number of days between two.
(see help on TDateTime).
I found two ways how to PRINT
the number of days between the current date and a date field.
1) Create calculated field DifDate (Integer or Float)
and write OnCalcFields handler as
procedure TForm1.Table1CalcFields(Da
begin
Table1DifDate.AsFloat := Now - Table1SaleDate.AsDateTime;
end;
set QRDBText component into report and set property DataField = DifDate
2) set QRLabel component into report
and write OnPrint handler as
procedure TForm1.QRLabel1Print(sende
begin
Value := FloatToStr(Now - Table1SaleDate.AsDateTime)
end;
-It's TimeToStr, not FloatToStr Vladika...
Sorry, I didn't understand that you need to put it in the Report. Does it works now with Vladika's sugestion?
Sorry, I didn't understand that you need to put it in the Report. Does it works now with Vladika's sugestion?
Why TimeToStr???
Let
Now = 7-aug-98
SaleDate = 6-aug-98
then
Now-SaleDate = 1
FloatToStr will print 1 (It's right answer, isn't it?)
and TimeToStr will print 00:00:00
Let
Now = 7-aug-98
SaleDate = 6-aug-98
then
Now-SaleDate = 1
FloatToStr will print 1 (It's right answer, isn't it?)
and TimeToStr will print 00:00:00
-Sorry, I meant DateToStr, not TimeToStr...
If it was more than 31 days? Then it won't be so easy. You'll have to use DecodeDate then, and add Month multiplied by 30-31.
If it was more than 31 days? Then it won't be so easy. You'll have to use DecodeDate then, and add Month multiplied by 30-31.
Why DateToStr???
From example above
DateToStr will print 31.12.1899 (if ShortDateFormat = 'dd/mm/yyyy')
I cannot understand why do you want to use DecodeDate procedure?
The DecodeDate procedure breaks the value specified as the Date parameter
into Year, Month, and Day values.
But Dif = Date1 - Date2 IS NUMBER of days between Date1 and Date2.
It's NOT DATE.
Dif can be negative (if Date1 < Date2).
But how write in help
If the given TDateTime value is less than or equal to zero,
the year, month, and day return parameters are all set to zero.
So, Date1-Date2 IS NUMBER of days between Date2 and Date1.
You do not need call DecodeDate at all.
Of course, to print this value (Dif) you may use not only FloatToStr function,
but others too.
I use FloatToStr only for example.
From example above
DateToStr will print 31.12.1899 (if ShortDateFormat = 'dd/mm/yyyy')
I cannot understand why do you want to use DecodeDate procedure?
The DecodeDate procedure breaks the value specified as the Date parameter
into Year, Month, and Day values.
But Dif = Date1 - Date2 IS NUMBER of days between Date1 and Date2.
It's NOT DATE.
Dif can be negative (if Date1 < Date2).
But how write in help
If the given TDateTime value is less than or equal to zero,
the year, month, and day return parameters are all set to zero.
So, Date1-Date2 IS NUMBER of days between Date2 and Date1.
You do not need call DecodeDate at all.
Of course, to print this value (Dif) you may use not only FloatToStr function,
but others too.
I use FloatToStr only for example.
ASKER
Matvey did not answer the question - answer by Vladika acceptable. Would like to rate him C.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The date in the field is
(Table1.fields[i] as TDateField).AsDateTime
Th other date value is
Date1: TDateTime
The difference is calculated as if you would substract two numbers:
Dif := Date1 - (Table1.fields[i] as TDateField).AsDateTime
You can extract the number of days from Dif by using
DecodeDate(Dif, Years, Month, Days);
Where
Years, Month, Days: Byte;
-Days will show then the number of days between the two.
--Matvey