How to format Date (mm/dd/yyyy to dd/mm/yyyy)

**gs.gopinath** · Jun 22nd, 2006, 08:11 AM

Hi,
How to format Date (mm/dd/yyyy to dd/mm/yyyy) . Please help me.

**si_the_geek** · Jun 22nd, 2006, 09:52 AM

Moved from CodeBank (which is for examples, not questions)

**Al42** · Jun 22nd, 2006, 11:25 AM

sdDate = Format$(smDate, "dd/mm/yyyy")

Where sdDate is a string variable that gets the date in dd/mm/yyyy format and smDate is a string variable having the date in mm/dd/yyyy format.

**Nexus7** · Jul 3rd, 2006, 09:01 AM

Originally Posted by Al42

sdDate = Format$(smDate, "dd/mm/yyyy")

Where sdDate is a string variable that gets the date in dd/mm/yyyy format and smDate is a string variable having the date in mm/dd/yyyy format.

This doesn't work. It still returns the format mm/dd/yyyy

**samsyl** · Jul 3rd, 2006, 09:05 AM

use dis

MsgBox Format(Date, "dd/MMM/yyyy")

**si_the_geek** · Jul 3rd, 2006, 09:07 AM

How are you actually using it?

Are you putting the value into a String variable (or a label caption etc), or are you putting it into a Date variable (which cannot contain formatting, so will use the default format).

**Nexus7** · Jul 3rd, 2006, 10:31 AM

I was applyng the format function to Date$ instead of Date

That seemed to be the problem

Thread: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Thread Tools

Display

How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Re: How to format Date (mm/dd/yyyy to dd/mm/yyyy)

Posting Permissions