Difference between dates

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
 
T

Thorson

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Countdown macro - display settings 2
Autofill Date in Word 15.33 for Mac 0
VBA - exporting serial letters to single documents 0
Date and Time Picker 6.0 0
Select Only Newest/Most Current date 5
Report Group Footer DLookUp 0
query to show where no data in a stated column 0

Top