Review M-Files on G2 & get a $25 gift card Arrow right Review us!

Options
  • Locked Locked
  • Replies 16 replies
  • Subscribers 9 subscribers
  • Views 2267 views
  • Users 0 members are here
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
  • If those workflow states are there simply for the notification sending then couldn't you just calculate the contract end date to a property and use standard notification rules to send out the notifications on the specified dates before the end date? No need to move the contract forward in the workflow for those notifications alone.
Reply
  • If those workflow states are there simply for the notification sending then couldn't you just calculate the contract end date to a property and use standard notification rules to send out the notifications on the specified dates before the end date? No need to move the contract forward in the workflow for those notifications alone.
Children
No Data
M-Files
M-Files Support


© 2024 M-Files, All Rights Reserved.