subtract on date

Topic

New Reply

i have this var
DATA_TIPOLOGIA=06/01/2010
how to subtract one month and have DATA_TIPOLOGIA=06/12/2009
note:
DATA_TIPOLOGIA is dimensioned string

Reply | Quote

Replies

For example:

Code:

	Dim DATA_TIPOLOGIA As String
	DATA_TIPOLOGIA = "06/01/2010"
	DATA_TIPOLOGIA = DateAdd("m", -1, DateValue(DATA_TIPOLOGIA))
	MsgBox DATA_TIPOLOGIA

Reply | Quote

For example:

Code:

	Dim DATA_TIPOLOGIA As String
	DATA_TIPOLOGIA = "06/01/2010"
	DATA_TIPOLOGIA = DateAdd("m", -1, DateValue(DATA_TIPOLOGIA))
	MsgBox DATA_TIPOLOGIA

work! tks.

Reply | Quote