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

Getting month and year date format in vbscript

Pravesh Singh 2883 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

Ask by Pravesh Singh

Updated 20 Jun 2013

1 Answers

Vijay Shukla 20 Jun 2013

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

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.