Solved

date/time format string (help with reading and writing a specific format)

Posted on 2011-09-21
5
199 Views
Last Modified: 2012-06-21
I need to read and write Date strings using the following format:
9/19/2011 8:10:58 PM

I have code that worked for years with myStreamWriter.WriteLine(Now) and DateTime.Parse(str), but now on a new machine with different locale settings the Parse is choking, and the WriteLine is using a different format.  To maintain legacy compatibility, I need to parse and write the timestamp as shown above.  I've spend a lot of time going in circles with Parse, and ParseExact, and different Format/Cluture infos, but still can't get it just right.

Any help greatly appreciated.
0
Comment
Question by:ottenm
  • 2
  • 2
5 Comments
 
LVL 17

Expert Comment

by:OriNetworks
ID: 36573278
I think this will force it to display in US English format
.ToString(New CultureInfo("en-US"))

0
 

Author Comment

by:ottenm
ID: 36573398
No luck OriNetworks, it doesn't include the year.
0
 
LVL 17

Accepted Solution

by:
OriNetworks earned 500 total points
ID: 36573452
See if any of these match your requirements.
http://www.geekzilla.co.uk/View00FF7904-B510-468C-A2C8-F859AA20581F.htm

Otherwise, I just format the date in my SQL query but im not sure if thats possible in your case.
SELECT Convert(varchar,getdate(),101) AS MyFormattedDate
0
 

Author Comment

by:ottenm
ID: 36573551
Thanks OriNetworks.  Using:

Now.ToString("M/d/yyyy h:mm:ss tt")
Dim dt As Date = DateTime.ParseExact(str, "M/d/yyyy h:mm:ss tt", Nothing)
0
 
LVL 40
ID: 36573570
yourDate.tostring ("MM\/dd\/yyyy hh:mm:ss tt",new Globalization.CultureInfo("EN-us"))
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

749 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