How to Calculate Late Date

  • Thread starter Thread starter benjamin.weierbach
  • Start date Start date
B

benjamin.weierbach

What's up Everyone?

I really need some help. I've been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I'm
trying to do:


DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES


If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I'd
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right? Thanks in advance for your help.
 
What's up Everyone?

I really need some help. I've been pulling the hair out of my head
trying to research how to calculate a late date. Here is what I'm
trying to do:


DATE VOUCHER SUBMITTED: 1 MAY 06
VOUCHER LATE?: YES


If the voucher is 5 days past the "DATE VOUCHER SUBMITTED" date, I'd
like to have it autmatically update another field named "VOUCHER LATE"
either with a yes/no answer. Is there a way to make this happen? If
there is, I should be able to query this info and create a report
right?
Click to expand...

If that rule is inviolatem then you have no need for a late
field. You can query on the 5 day rule by using a criteria
on the submitted date:
<= DateAdd("d", -5, Date())

If you save the late calculation, then it will become
incorrect until you do some other action to recalculate it.

The display on the form can use a similar expression to
display the yes/no whenever you view the record:
=IIf([Date Submitted]<=DateAdd("d",-5,Date()),"Yes","No")
 
Back
Top