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 over 3 years ago

' 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 over 3 years ago

Thank you for the quick response.

yes, im about to use it in a workflow transition trigger.

what i mean on ( szDate = szDate2 ) is to change current date with the result in DateAdd("d",-135,szContractEndDate)

szDate = DateSerial(Year(Now), Month(Now), Day(Now))
szDate2 = DateAdd("d",-135,szContractEndDate)

Appreciate your help
Cancel
Vote Up 0 Vote Down

Cancel

Reply

Former Member over 3 years ago

Thank you for the quick response.

yes, im about to use it in a workflow transition trigger.

what i mean on ( szDate = szDate2 ) is to change current date with the result in DateAdd("d",-135,szContractEndDate)

szDate = DateSerial(Year(Now), Month(Now), Day(Now))
szDate2 = DateAdd("d",-135,szContractEndDate)

Appreciate your help
Cancel
Vote Up 0 Vote Down

Cancel

Children

No Data