Date format of MM/DD

Posted on 2008-11-05
Medium Priority
Last Modified: 2012-05-05
I have date fields that are all printing MM/DD/YYYY  

How can I change that to print only MM/DD
Question by:pinkstonm
  • 2
LVL 54

Accepted Solution

Ryan Chong earned 200 total points
ID: 22885764
try use a customize function:


function toMMDD(v)
   if isdate(v) then
         toMMDD = right("0" & month(v),2) & "/" & right("0" & day(v),2)
  end if
end function



response.write toMMDD(yourdateValue)
LVL 54

Expert Comment

by:Ryan Chong
ID: 22885770
or if you date value is from database, you can format it in your Select SQL statement instead.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question