Options
  • Locked Locked
  • Replies 16 replies
  • Subscribers 5 subscribers
  • Views 1386 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Need Help in VBScript

Former Member
Former Member
' Get Contract End Date

Dim szContractEndDate

szContractEndDate = PropertyValues.SearchForProperty( 1306 ).TypedValue.DisplayValue

Dim szDate

szDate = DateSerial(Year(Now), Month(Now), Day(Now))

Dim szDate2

szDate2 = DateAdd("d",-135,szContractEndDate)

szDate = szDate2



I want to set  szDate2 to be trigger date for email notification
Parents
  • Former Member
    Former Member
    I have attached the image of my workflow.

    So when the Pending proposal state is reached, szContractEndDate (property.value) will less 135 days i want the result to be the workflow state trigger date basis.

    Contract End Date is a future date and we want to get notified 60 days, 45 days, 30 days (total of 135) before the contract end date.

    I'm not sure maybe there's an easy on doing this.

    Appreciate your help.
Reply
  • Former Member
    Former Member
    I have attached the image of my workflow.

    So when the Pending proposal state is reached, szContractEndDate (property.value) will less 135 days i want the result to be the workflow state trigger date basis.

    Contract End Date is a future date and we want to get notified 60 days, 45 days, 30 days (total of 135) before the contract end date.

    I'm not sure maybe there's an easy on doing this.

    Appreciate your help.
Children
No Data




              

© M-Files Corporation 2024 | Privacy Policy