Ignore future dates

T

Tom Owen

How do I get a module to ignore future dates in
calculations?

For example say Date1 minus Date 2 returning a value in
days.
 
J

John Mishefske

Tom said:
How do I get a module to ignore future dates in
calculations?

For example say Date1 minus Date 2 returning a value in
days.
Click to expand...
Without knowing more I'd say that you limit the date with a
test in your calculation:

IIF([yourDate] > Date, Date, [yourDate])

So you might have:

IIF([Date1] > Date, Date, [Date1]) - IIF([Date2] > Date, Date, [Date2])

this prevents future dates.
 
Top