Date Comparisons

Question:
I cannot find much info on how to do Date math. I am trying to determine elapsed days from a record entry date to the current date. I am spoiled by dBASE date functions where I just subtract one date from the other and it gives me the days. If I subtract a date from enterdate I can get a number returned that looks correct until I start spanning months and/or years.

Answer:
Cast the date value as a TDateTime value: TDateTime(myDateVal), then do yourmath. You’ll get accurate answers this way when spanning years.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: