Date subtraction

[Stephanie]

Hi.
I'm trying to perform a date subtraction between incident date and discovery
date, but I can't get the syntax correctly. I'd like to have the output in
"days".

Could you please provide guidance on how to use the date function. Thanks.

 

[KARL DEWEY]

DateDiff("d", [Incident], [Discovery])
If they are the same day then the above will result in 0 (zero) as there is
no difference.
DateDiff("d", [Incident], [Discovery])+1
This will give you one day if they are the same day.

 

[John Spencer]

Use the DateDiff function.

DateDiff("d",[Incident Date],[Discovery Date])



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Stephanie]

Thanks!

DateDiff("d", [Incident], [Discovery])
If they are the same day then the above will result in 0 (zero) as there is
no difference.
DateDiff("d", [Incident], [Discovery])+1
This will give you one day if they are the same day.
--
Build a little, test a little.

Hi.
I'm trying to perform a date subtraction between incident date and discovery
date, but I can't get the syntax correctly. I'd like to have the output in
"days".

Could you please provide guidance on how to use the date function. Thanks.