How to convert date format from mm/dd/yyyy to dd:mm:yyyy?

Replies to This Discussion

Permalink Reply by Teemu Vesala on November 25, 2010 at 6:23pm

I'm sorry, but in my opinion you should find it out yourself. VB Script is supported at all MS Office products, so do the code there. At testing the problem solving is one of the most important skills. And asking help from forum at very simple question is not correct problem solving. It's rather cheating.

I don't mean to be nasty for you. I hope this is rather helping and encouraging you to find out things yourself. And also I hope this encourages you to try things you've never tried before.

• ▶ Reply

Permalink Reply by k.vijay on November 25, 2010 at 6:24pm

v1=date()
vsplit=split(v1,"/")
v2=vsplit(1)&"-"&vsplit(0)&"-"&vsplit(2)
msgbox v2

• ▶ Reply

Permalink Reply by Ammad Alam on November 25, 2010 at 6:39pm

Nivas See this may be it will help you
http://databases.aspfaq.com/general/can-i-fix-this-mm/dd/yyyy-dd/mm...

• ▶ Reply

Permalink Reply by Riyaj A Shaikh on November 25, 2010 at 6:51pm

http://tinyurl.com/36q9adx

• ▶ Reply

Permalink Reply by vivek on November 25, 2010 at 7:09pm

try this

s = Day(Date) & "/" & Month(Date) & "/" & Year(Date)

us string replace function find / replace with

hope this will help

• ▶ Reply

Permalink Reply by Kumar on November 25, 2010 at 7:43pm

Hi,

All above answers tell you to convert system date to dd:mm:yyyy or d:mm:yyyy or dd:m:yyyy or d:m:yyyy, but not given date.There is different approach to convert system date to dd:mm:yyyy.

iDate = "25/11/2010"
DateArray = Split(iDate, "/")
fDate = DateArray(0) & ":" & DateArray(1) & ":" & DateArray(2)
Msgbox(fDate)

• ▶ Reply

Permalink Reply by Bibin Babu on November 26, 2010 at 9:35am

Hi Nivas,

Try this, may be helpful.................

Dim vDate
Dim vMonth
Dim vYear
Dim vSystemDate
Dim vConverted_Date

vSystemDate = Date

vDate = Datepart("d",vSystemDate)
vMonth = Datepart("m",vSystemDate)
vYear = Datepart("yyyy",vSystemDate)

If len(vDate) = 1 then
vDate = "0" & vDate
Else
vDate = vDate
End If

If len(vMonth) = 1 then
vMonth = "0" & vMonth
Else
vMonth = vMonth
End If

vConverted_Date = vDate & ":"&vMonth & ":" & vYear
msgbox vConverted_Date


Best Regards,
Bibin Babu

• ▶ Reply

Permalink Reply by Chandan Pandit on December 3, 2010 at 12:54pm

set Dateformat DMY

• ▶ Reply