Simple Lotus If Statement

It depends on where and when you want set the value. So if you could give some additional info...

There are two fields.  One is confirmed (which is a yes/no).  And the other is date confirmed.  I want date confirmed to automatically populate to be today's date.  I'm using Designer and am assuming that this goes as the default value for date confirmed?  Should it go somewhere else?

I put this in the default value section for DateConfirmed.  there were no errors, but it did not work.  Do i put is somewhere else.  Possibly in the ZeroBundleConfirmed Section?
@If(ZeroBundleConfirmed="y"; @Setfield("DateConfirmed"; Today); "")

I'm getting an error when i put in @If(ZeroBundleConfirmed="y" & !IsTime(dateconfirmed); @Today; dateconfirmed)

It says @FunctionOperator expected  or @ Function does not require argument : ')'

Triple @%$#%! Another typo (it's not my day), also IsTime is a Formula function, it should be @IsTime...

@If(ZeroBundleConfirmed="y"; @today;DateConfirmed)

Partha

Hey Partha! Go to work, bro.

Not good anyway, because if one saves the document a second time, the DateConfirmed will be overwritten.

HI Bro

Thx for the advice :), It all depends on whether the field is computed for display or composed and his logic though !

partha

Do we agree that we disagree? ;)

Ok..I did this and it worked : @If(ZeroBundleConfirmed="Yes"; @Today; DateConfirmed)

However, now I have to update an agent.  The code is as below

FIELD ZeroBundleConfirmed := ZeroBundleConfirmed;
@If(Except="Yes";@Prompt([Ok];"Error";"This Bundle can not be confirmed because the 'Does an exception need to be filed for this bundle?' field equals Yes.");@SetField("ZeroBundleConfirmed"; "Yes"));SELECT @All

I want to updated the DateConfirmed equal to today's date when the ZeroBundleConfirmed is set to yes.  

Again, I vow 500 points and an A

@If(ZeroBundleConfirmed="Yes"; @Today; DateConfirmed), this line does that only

Partha

Don't forget to check if the document was already confirmed, with the code above you will overwrite the original confirmation date! That's why I used @IsTime

So i can just put the field statement at the beginning?

Since you both are being so helpful, i'll post this question again and ask one of you to respond with the same answer.  that way I  can give you both 500 points and an A.

You can split the points,
As sjef was first, please give him take the lion's share

Partha

typo "As sjef was first, please give him the lion's share "

:)

Partha

I'll do whatever makes ya'll happy.  You've both been so helpful I just wanted to make sure you both got a bunch of points.

Any thoughts on the agent?

THe line i gave :
field dateconfirmed:=@If(ZeroBundleConfirmed="Yes"; @Today; DateConfirmed);

can  be added in the agent only

Partha