caseyuptobat Posted August 10, 2007 Share Posted August 10, 2007 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 Link to comment Share on other sites More sharing options...
AudioFreak Posted August 10, 2007 Share Posted August 10, 2007 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 Link to comment Share on other sites More sharing options...
caseyuptobat Posted August 10, 2007 Author Share Posted August 10, 2007 What call out do I use to make the date appear in my "End Date" field? Link to comment Share on other sites More sharing options...
AudioFreak Posted August 10, 2007 Share Posted August 10, 2007 This should help some. See attached. Michael caseyuptobat.zip Link to comment Share on other sites More sharing options...
caseyuptobat Posted August 10, 2007 Author Share Posted August 10, 2007 Your awesome thanks. I was putting the calcualation as a calc and not as a date. Thank you for your help. Jason Link to comment Share on other sites More sharing options...
AudioFreak Posted August 10, 2007 Share Posted August 10, 2007 I mislead you that direction. Glad you got it working :( Link to comment Share on other sites More sharing options...
Ender Posted August 10, 2007 Share Posted August 10, 2007 Case (Status="cancelled" ;Get ( CurrentDate );Status="Denied" ; Get ( CurrentDate ) ;Status="Lapsed" ; Get ( CurrentDate ) ) This would be a good place for the OR operator. Link to comment Share on other sites More sharing options...
AudioFreak Posted August 10, 2007 Share Posted August 10, 2007 True. Sometimes it's tough to get away from your old ways....lol Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6195 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now