Comparing expiry date to "current date"

[exposbabe]

Hi, helpful folks,
I'm having a heck of a time with the "Current Date" concept.

It seems like a simple enough thing to do, but I just can't get it to work.

I have customers with subscriptions, each with an expiry date.

I have a field that indicates whether that customer is "active" or "inactive", calculated by whether the expiry date is before or after today's date (before makes it inactive; after makes it active).

I just can't seem to get today's date to update for every record. Every time it seems to work, something gets messed up.

Any help will be appreciated.

The Get Current date function doesn't seem to work, else I just am not doing it properly.

Thanks.

 

[JeanW]

When you use the Get(CurrentDate) function, make sure the calc result is unstored.

It could be good to post your calcs, it's a little vague now to point to the possible problem.