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.