Calculation in rules

Forums General discussion Calculation in rules

This topic contains 4 replies, has 3 voices, and was last updated by  Alexander Bautz 1 month, 2 weeks ago.

  • Author
    Posts
  • #9814

    Gerard Graham
    Participant

    Hi there

    Is there a way of triggering a rule based on a calculation? For example if a the difference between two dates is greater than 30 days? I know this can be done in the Validation Settings for the list, but I’d like the message to appear when the end date changes rather than when the user attempts to save the record.

    Thanks

    Gerry

  • #9846

    Alexander Bautz
    Keymaster

    Currently you can do this calculation with [today] by comparing with [today]+30 (not currently documented), but not when comparing two date columns. I will however add this to the next release – BETA hopefully later tonight.

    Alexander

  • #9859

    Gerard Graham
    Participant

    Cheers

  • #22638

    Matthew Thompson
    Participant

    was this able to be added? if so what would the calc be?

  • #22642

    Alexander Bautz
    Keymaster

    Hi,
    You should be able to create a rule triggering on is greater than on lets say EndDate and select {StartDate}+30 in the This value field.

    Alexander

You must be logged in to reply to this topic.