×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Using a calculated Date field for Due Date in a Three-state workflow

Using a calculated Date field for Due Date in a Three-state workflow

Using a calculated Date field for Due Date in a Three-state workflow

(OP)
Hello.

I have a sharepoint list where I have created a column called 'Expiration Date'. I created a calculated Date column (Calculated based on other columns) that takes Expiration Date minus 30 days called Renewal Date. So if Expiration date is 2/1/2013, the Renewal Date will have 1/1/2013. I then created a Three-state workflow for these list items to enable email reminders and am trying to set the Task Due Date properties, but the Renewal Date is not appearing in the dropdown. I'm guessing it is because only pure Date fields are allowed but the Renewal Date was set to Date type.

I don't have access to Sharepoint Designer and am limited to what I have permissions to do. Is there a workaround? I've lost my mind searching online.

RE: Using a calculated Date field for Due Date in a Three-state workflow

Hi,

Quote:


So if Expiration date is 2/1/2013, the Renewal Date will have 1/1/2013.
So how does [expiration date] - 30 get you 1/1/2013 when Jan has 31 days? Is that because "the Renewal Date was set to Date type."? That was an immediate red flag in my book!

Skip,

glassesJust traded in my old subtlety...
for a NUANCE!tongue

RE: Using a calculated Date field for Due Date in a Three-state workflow

(OP)
It was just an example. [expiration date]-30 will get me 1/2/2013, which is fine. I just need it to be able to allow this. And Renewal Date is a calculated field set to type Date.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close