Date() datediff confusion

  • Thread starter Thread starter Dani
  • Start date Start date
D

Dani

Hello all. I am trying to create a report that show all of the parts
that are late. I wanted to report of show something like this:

part# , qty, desiredDate, etc.

Now if the desired date is before the today's date, I would like to be
able to add "order late by" and then number of days late.

Is this possible. I know some out there has a bigger brain than I do
and can figure this out right away.

Thanks Dani
 
Hello all. I am trying to create a report that show all of the parts
that are late. I wanted to report of show something like this:

part# , qty, desiredDate, etc.

Now if the desired date is before the today's date, I would like to be
able to add "order late by" and then number of days late.

Is this possible. I know some out there has a bigger brain than I do
and can figure this out right away.

Thanks Dani
Click to expand...

In an unbound control:
=IIf([DesiredDate] < Date(),"Order late by " & Date() - [DesiredDate]
& " days.","")
 
Back
Top