Converting DateTime Values to customized format

[Knoppers]

Hi all,

I have some problems converting some values into a user defined format.

The code:

Print("Date1: " + ToDay(Time[0]).ToString());
Print("Date2: " + ToDay(Time[0]).ToString("yyyy-MM-dd"));
Print("Open: " + Open[0]);
Print("High: " + High[0]);
Print("Low: " + Low[0]);
Print("Close: " + Close[0]);
Print("Volume: " + Volume[0]);

The result set:

Date1: 20120127
Date2: yyyy-MM-dd
Open: 1314,75
High: 1319,25
Low: 1307
Close: 1312,75
Volume: 1730153


Here my problem: I would like to have the date (as a string) in format: "YYYY-MM-DD" and all the the values with a "." instead of "," as seperator.

Can anyone please provide some code snippets to me?


Thanks in advance!

Knoppers

[koganam]

Here it is in all its glory, courtesy of a little Google-Fu.

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

https://www.google.com/search?q=string+format+for+datetime

[NinjaTrader_Joydeep]

Hello Knoppers,
Thanks for your post and I am happy to assist you.
Please try these codes:

Print("Date1: " + Time[0].ToString("yyyy-MM-dd")); 
Print("Date2: " + Time[0].ToString("yyyy-MM-dd")); 
Print("Open: " + Open[0].ToString(System.Globalization.CultureInfo.GetCultureInfo("en-US").NumberFormat)); 
Print("High: " + High[0].ToString(System.Globalization.CultureInfo.GetCultureInfo("en-US").NumberFormat));
Print("Low: " + Low[0].ToString(System.Globalization.CultureInfo.GetCultureInfo("en-US").NumberFormat));
Print("Close: " + Close[0].ToString(System.Globalization.CultureInfo.GetCultureInfo("en-US").NumberFormat));

@koganam thanks for your input.

Please let me know if I can assist you any further.

[Knoppers]

Hi Joydeep & koganam,

thanks a lot for your hints and your perfect support!

Works perfectly...

[NinjaTrader_Joydeep]

Hello Knoppers,
Glad to know it worked for you.

Please let me know if I can assist you any further.