<div>
Hi,<br />
I am getting it in the correct it in the correct format. I tried the same code that you have specified. I dont think you have any problem with your SelectedDate statement.<br />
<br />
Thanks,<br />
Anandavally P
</div>


Hi,
I am getting it in the correct it in the correct format. I tried the same code that you have specified. I dont think you have any problem with your SelectedDate statement.

Thanks,
Anandavally P

<div>
e1v that did the job, (MM/dd/yyyy) so does that mean the db is setup in US Format?
</div>


e1v that did the job, (MM/dd/yyyy) so does that mean the db is setup in US Format?

<div>
<div class="content wysiwyg-content">
<br />
it seems no matter what I try I cannot return correct date values from my select statement, fo example I have a calender<br />
control which the user selects the date then click a button to run<br />
<br />
string startdate = string.Format(&quot;#{0:dd/MM/y<wbr />yyy}#&quot;, Calendar1.SelectedDate);<br />
select....WHERE ([dbx].[Arrival Date]= &quot;&nbsp;+ startdate + &quot;)&quot;;<br />
<br />
so i select 01/07/06 but returns 07/01/06<br />
<br />
..help
</div>
</div>



it seems no matter what I try I cannot return correct date values from my select statement, fo example I have a calender
control which the user selects the date then click a button to run

string startdate = string.Format("#{0:dd/MM/yyyy}#", Calendar1.SelectedDate);
select....WHERE ([dbx].[Arrival Date]= " + startdate + ")";

so i select 01/07/06 but returns 07/01/06

..help

UK DateFormat

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).