Date operation ASP and SQL server 2005

ODBC Drivers for QuickBooks, Salesforce, SAP, MSCRM, SharePoint … Free Trial!

This examples shows the substraction, relational operations with dates.

test = date()

testmonth = month(test) - 6

testd = month(testmonth) & "/" & day(test) & "/" & year(test)

testyear = year(testd)

If month(testd) > month(test) then
testyear = year(testd) - 1
End if

testdate = month(testd) & "/" & day(testd) & "/" & testyear

response.write test & "<br>"
response.write testd & "<br>"
response.write testdate  & "<br>"

Popularity  (843 Views)