Difference between dates

  • Thread starter Thread starter Thorson
  • Start date Start date
T

Thorson

In a query if I want to calculate how long an animal has been pregnant to
this date can't I just use this:

GestationLength: Date()-[qryAIandCUbulls]![AIDate]

[qryAIandCUbulls]![AIDate] is the date the animal was bred. For some reason
this is showing up as an #Error
 
Works Perfectly! Thanks
--
Thorson


KARL DEWEY said:
Try this --
GestationLength: DateDiff("d", Date(), [qryAIandCUbulls].[AIDate])

--
Build a little, test a little.


Thorson said:
In a query if I want to calculate how long an animal has been pregnant to
this date can't I just use this:

GestationLength: Date()-[qryAIandCUbulls]![AIDate]

[qryAIandCUbulls]![AIDate] is the date the animal was bred. For some reason
this is showing up as an #Error
Click to expand...
Click to expand...
 
Back
Top