FORMULE FOR FORMATTING DATE ENTRIES FOR NOTIFICATION AGAINST A SP.

[Guest]

Pls send the formulae for expiry notification for a set of date entries

 

[Ofer]

Can you be more specific

 

[Ed Warren]

I think what you are asking for is a query "select all records from a table
with a date entry that is before some selected date"

A query something like:

SELECT * from table where
[date] < [selected date]

Note: you never actually see this bit of code if you use the built in query
builder, just drop in the fields you want in your result and fill in the
criteria for the [date] field (< [selected date] or if you are interested in
any before today : < now())

Should get you started

by the way: All caps ==> shouting at the group and shows anger (is this
what you intended?)

Ed Warren