Date calculation

[Turansky]

Hello,

I have this calculation that checks the date against today's date and then assigns the field active or expire. And it works . . . sort-of.

The problem is I want it to check this on a daily basis so it could change the status when the date does expire. Any ideas?

Kent

If(Date( TextToNum(expiremonth), TextToNum(expireday), TextToNum(expireyear) ) >= Today,"active","expire")

[andygaunt]

Hi ,

First make your calculation unstored and I would suggest using Status(CurrentDate) as opposed to the today option.

Making it unstored will mean it recalculates itself every day.

[Turansky]

That was an easy fix.

Thank you

Kent