Beware of slashes when formatting dates [ All Languages » VB »  Date-Time] Total Hit ( 2869) Rate this article:     Poor     Excellent   Submit Your Question/Comment about this article Rating

You probably use the Format function to format date, for example: Click here to copy the following block ? Format(Now, "mm/dd/yyyy")   ' => 08/01/2001   ? Format(Now, "mm+dd+yyyy")   ' => 08+01+2001 It seems that this is everything you need to know, right? However, the story is quite different when regional settings set a different date separator. Let's say that "-" is the end user's date separator. The result from the slash character in Format is now different: Click here to copy the following block ? Format(Now, "mm/dd/yyyy")   ' => 08-01-2001 (the new separator!)   ? Format(Now, "mm+dd+yyyy")   ' => 08+01+2001 In most cases this behavior doesn't break your code: after all the end user will see dates formatted her own way. But if you're using the result in a SQL statement, you must comply with the database settings, and use the slash. The simplest way to ensure that the result uses the slash separator is to use another character and then replace it with the slash: Click here to copy the following block ? Replace(Format(Now, "mm_dd_yyyy"),"_","/")  ' => 08/01/2001

Related Article(s)

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)
	Job Description : He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )