locked
Date Trigger RRS feed

Answers

  • Hi Migs,

    Since you want the alert to go out 2 weeks before the expiration date you should add a calculated column to your list to calculate expiredDate - 2 weeks.

    Create a new column - call it ExpNotice (or something like that).  Choose the type as calculated. Format as Date.  For the fomula use:

    =[ExpirationDate] - 14

    You actually won't be using a condition for this.  You need to create a workflow to start when a new item is created.  As the action, choose Pause for Duration.  Tell it to pause until [insert date field here for calculated column].  Then add your 2nd action of send an email.


    • Edited by Melissa Renton MCTS Thursday, July 7, 2011 1:56 PM Edited to add calculated column format
    • Marked as answer by Migs723 Friday, July 8, 2011 11:09 AM
    Thursday, July 7, 2011 1:13 PM

All replies

  • Hi Migs,

    Since you want the alert to go out 2 weeks before the expiration date you should add a calculated column to your list to calculate expiredDate - 2 weeks.

    Create a new column - call it ExpNotice (or something like that).  Choose the type as calculated. Format as Date.  For the fomula use:

    =[ExpirationDate] - 14

    You actually won't be using a condition for this.  You need to create a workflow to start when a new item is created.  As the action, choose Pause for Duration.  Tell it to pause until [insert date field here for calculated column].  Then add your 2nd action of send an email.


    • Edited by Melissa Renton MCTS Thursday, July 7, 2011 1:56 PM Edited to add calculated column format
    • Marked as answer by Migs723 Friday, July 8, 2011 11:09 AM
    Thursday, July 7, 2011 1:13 PM
  • Thanks will try this and let you know who i did, :)

    Note to later deleted post from Migs723 said " It was resolved by Melli"

     

    • Edited by Mike Walsh FIN Friday, July 8, 2011 12:12 PM Note to later ... sentence added prior to lock
    Thursday, July 7, 2011 2:13 PM