WeekSpan
WeekSpan returns the approximate number of weeks between two specified TDateTime values, including the fraction of those weeks.
For example, WeekSpan reports the difference between 12:00 A.M. on 13th February and 11:59 P.M. on 19th February as 0.99990079365047 of a week, because it is one (1) minute short of a full week.
If you want a function that only returns a full number of weeks as an integer with no fraction, please review WeeksBetween.
The ordering of the two dates doesn't matter - the number of weeks will not be a negative value.
Declaration: Function WeekSpan(const ANow, AThen: TDateTime): Double;
Examples follow.
procedure OnMapEvent(var Value:Variant);var TheDate, ThatDate : TDateTime; NumBetw : double;begin //Result is 0.99990079365047 TheDate := EncodeDateTime(2023, 02, 13, 00, 00, 00, 000); ThatDate := EncodeDateTime(2023, 02, 19, 23, 59, 00, 000); NumBetw := WeekSpan(TheDate,ThatDate); LogInfo('The number of weeks between these dates is - '+FloatToStr(NumBetw)); //Result is 1.0 ThatDate := EncodeDateTime(2023, 02, 20, 00, 00, 00, 000); NumBetw := WeekSpan(TheDate,ThatDate); LogInfo('The number of weeks between these dates is - '+FloatToStr(NumBetw)); end;