Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / getting month and year date format in vbscript
Ask Question

Getting month and year date format in vbscript

Pravesh Singh 2835 20 Jun 2013
Hi,

Can someone please tell me how can we get data in the month and date format.In the below code it shows me the year with the same date one year ago in the format 6/18/2012 ..but I just need the month/year.

LastMonth = DateAdd("m",-12,Date)

Thanks

vb script vb script
Updated 20 Jun 2013
Pravesh Singh
Pravesh Singh

Other

Student

Message

1 Answers

Vijay Shukla
Vijay Shukla 20 Jun 2013
Report Abuse
Hi Expert!

Use the specialized functions Month(), Year(), ... to get at the private parts of a (variable of type) Date:

dt = DateAdd("m",-12,Date)
WScript.Echo TypeName(dt), CStr(dt), Month(dt) & "/" & Year(dt)

Date 6/18/2012 6/2012
MindStick Training