calculate difference between dates

[SylvieB]

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date

awarddate.

=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie

 

[KARL DEWEY]

IIF(Date() > [awarddate], dateDiff("d",[awarddate], Date()), "")

--
Build a little, test a little.

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date

awarddate.

=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie

 

[Wayne-I-M]

IIf([TableName]![AwardDate]<Date(),DateDiff("d",[TableName]![AwardDate],Date()))

IIf([TableName]![AwardDate]>Date(),DateDiff("d",[TableName]![AwardDate],Date()))


Not sure what you looking for - one of them is correct
either award before or after today


--
Wayne
Manchester, England.

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date

awarddate.

=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie

 

[Jerry Whittle]

IIf([awarddate] < Now(),DateDiff("d",[awarddate], Now()),0)

This will return a 0 if the awarddate is greater than Now. You could change
the 0 to Null.

Now if you just want those records returned at all, you could put >0 in the
critieria of a field like below:

AwardCalc: DateDiff("d",[awarddate], Now())
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date

awarddate.

=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie

 

[SylvieB]

Thank you ALL very much. It works great.

IIf([awarddate] < Now(),DateDiff("d",[awarddate], Now()),0)

This will return a 0 if the awarddate is greater than Now. You could change
the 0 to Null.

Now if you just want those records returned at all, you could put >0 in the
critieria of a field like below:

AwardCalc: DateDiff("d",[awarddate], Now())
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date

awarddate.

=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie

 

[Wayne-I-M]

I take it from the lack of a tick that you didn't like my answer. OK.

But if your report is based on a query (which I assume it is) then you would
be better placing the calculation in the query and using the results in the
report.

we can but try to help ?


--
Wayne
Manchester, England.

Thank you ALL very much. It works great.

IIf([awarddate] < Now(),DateDiff("d",[awarddate], Now()),0)

This will return a 0 if the awarddate is greater than Now. You could change
the 0 to Null.

Now if you just want those records returned at all, you could put >0 in the
critieria of a field like below:

AwardCalc: DateDiff("d",[awarddate], Now())
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Hello group
On a report, i need to calculate the aging days between today's date and
award date but only if today's date is greater than award date.
Here what i have so far. I don't know how to filter it only if today's date
awarddate.
=dateDiff("d",[awarddate], Now())

Thank you in advance for any help.
Sylvie