Ignore future dates

[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.

 

[John Mishefske]

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

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

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.