Days Differencent calculation

F

Faio

Can anyone help me on this.

I have a field called ARRIVALDATE that stores the Vessel arrival date. I
wish to create a Query that after the arrival date of 35days, It will
display the word "Storage Charge Due" else "No STorage charge".

If it can also send an email notification when the 35days due, please
specify how to do it.

Appreciate any help.
 
R

Rosco

Add this into your query grid. Change the table name to your actual
table.

Expr1: IIf(DateDiff("d",Now(),[tblDates].[ARRIVALDATE])>35,"Storage
Charge Due","No Storage Charge")

Can't help you with the email.

Rosco
 
Top