Need help finishing calculation

[caseyuptobat]

Simply what I am trying to do is whenever I mark a client canceled, denied, or lapsed I would like a date to show up in the "end date" field. What I have so far is:

If (Status = "Canceled; "Denied"; "Lapsed")

Can anyone finish this for me for an automatic date to enter.

Thank you for your help.

Jason

[AudioFreak]

Make a calculation field of Date type and use this.

Case (Status="cancelled" ;Get ( CurrentDate );Status="Denied" ; Get ( CurrentDate ) ;Status="Lapsed" ; Get ( CurrentDate ) )

HTH

Michael

[caseyuptobat]

What call out do I use to make the date appear in my "End Date" field?

[AudioFreak]

This should help some. See attached.

Michael

caseyuptobat.zip

[caseyuptobat]

Your awesome thanks. I was putting the calcualation as a calc and not as a date.

Thank you for your help.

Jason

[AudioFreak]

I mislead you that direction. Glad you got it working :(

[Ender]

Case (Status="cancelled" ;Get ( CurrentDate );Status="Denied" ; Get ( CurrentDate ) ;Status="Lapsed" ; Get ( CurrentDate ) )

This would be a good place for the OR operator.

[AudioFreak]

True. Sometimes it's tough to get away from your old ways....lol