Re: Add Months to Date

derickson — Wed, 26 Sep 2012 20:59:46 GMT

Can i get this not in code? I want to either create a rule to do this or a formula to do this. I try the AddMonths but I get invalid syntax.

Re: Add Months to Date

lukeksmith — Tue, 21 Apr 2009 18:12:43 GMT

thanks for the reply! this worked perfect.

Re: Add Months to Date

ocampod84 — Tue, 21 Apr 2009 18:01:04 GMT

You need to use the AddMonths method of the Date class. This should get you started:

Once you enter the number of months for the contract, the code will produce the date by using the AddMonths method.

Public Sub field2_Changed(ByVal sender As Object, ByVal e As XmlEventArgs)

' Write your code here to change the main data source.

Dim DOM As XPathNavigator = MainDataSource.CreateNavigator()

' Create reference to date picker

Dim datePickerNode As XPathNavigator = DOM.SelectSingleNode("/my:myFields/my:field1", NamespaceManager)

' remove nil attribute from node

DeleteNil(datePickerNode)

' Create reference to contract months

Dim contractMonthsNode As XPathNavigator = DOM.SelectSingleNode("/my:myFields/my:field2", NamespaceManager)

' Create reference to contract end date

Dim contractEndDate As XPathNavigator = DOM.SelectSingleNode("/my:myFields/my:field3", NamespaceManager)

' remove nil attribute from node

DeleteNil(contractEndDate)

' get the values

Dim contractDate As Date = datePickerNode.ValueAsDateTime()

Dim contractMonths As Integer = contractMonthsNode.ValueAsInt()

' do the math and return values

contractEndDate.SetValue(contractDate.AddMonths(contractMonths).ToShortDateString)

End Sub

' The following sub is required to work with dates!!

Public Sub DeleteNil(ByVal node As XPathNavigator)

If (node.MoveToAttribute( _

"nil", "http://www.w3.org/2001/XMLSchema-instance")) Then

node.DeleteSelf()

End If

End Sub

Add Months to Date

lukeksmith — Wed, 15 Apr 2009 17:33:56 GMT

I'd like to have a date picker control for a contract date, a text field for contract months, and another field for contract expiration date where expiration date = contract date + contract months

AddDays() simply won't cut it because I need the day to be the same every month.

Could someone be nice and offer some code (vb preferably).

Thanks

Code

Re: Add Months to Date

Re: Add Months to Date

Re: Add Months to Date

Add Months to Date