First, as a new Filemaker user I have been using this forum almost every day and would like you all to know that your help is very much appreciated. Thanks.

Now the problem. Probably an easy answer but as I said I am new.

Have a database with a field called ACTIVE.

I would like to have that be a calculation field that says [color:red]ACTIVE (TEXT) when today’s date falls between the dates in the fields Joindate and Expiration date.

I just can’t figure out the calc.

How do I calculate for today’s date and where does it go? I am thinking it must be a variable but I have very, very, very little programming experience and no formal or even informal training other than what I have taught myself.

Thanks for any help and it is greatly appreciated.

Fred

If( Get(CurrentDate) >= FirstDate and Get(currentDate) <= SecondDate ; "Active" )

Put that in an unstored calculation field and set result type to be text.

HTH

Thanks that did it :P