Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to Convert Date 5/6/2003

Status
Not open for further replies.

zaq888

MIS
Jun 2, 2003
46
MY
How can i convert 5/6/2003 to 6 MAY 2003 format?

I'm Keep Studying.... please show the way...
Not Good in English
 
Hi zaq888

Use the Format command eg ..

To print "5/6/2003" as 5 June 2003, use

Code:
Format(DateField,"d mmmm yyyy")

Look up the format command and masking in the MSDN doco for more information on what is possible with this command.

 
zaq888,
you can try
format("5/3/2003","Medium date")
or
format("5/3/2003","dd mmm yyyy")
 
thanks ps42, thats the best way

I'm Keep Studying.... please show the way...
Not Good in English
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top