Problem with Replace Field Contents

[sykot]

Hello guys,

I have a question i got two Tables

1. Want to sign out

2. Signed out

With the function i want that if Want to sign out = Yes and its the month ( 1 ) then the field Signed out need to be YES

but if its not Month ( 1 ) then it need to be still remain at NO

Can some one help me i am going to be crazy

Here a screenshot http://webdisk.planet.nl/dalga000/publiek/album/functiefout.jpg

[comment]

i got two Tables

Your screenshot shows it is two FIELDS (which makes more sense).

its the month ( 1 )

Not sure what that means. If you want to test that today is the month of January, use:

Month ( Get (CurrentDate) ) = 1 

However, you should consider what will happen if you run your script in February. The way you have it now, all those who have signed out in January, will revert to "unsigned".

[sykot]

Thank you for your help it works thanks....

Well i make this for membership. The membership starts at September and ends September of new school year. So my point is if some one want to sign out in january, it need to stay in the list until month september and from september it need to signed out..... Will this work?

[comment]

I would make it this way:

When someone wants to sign out, enter the date of their request in the first field. Make the second field a calculation field that returns the date (in the upcoming month of September) when the request will take effect.

[sykot]

I got it but whats the difference with if i do Month ( Get ( Currentdate ) ) =1 and the way what you are telling?.

[comment]

My way, there is no script and it doesn't matter what date it is today - you opt out in March and you are already signed out beginning next September.