<div>
Try to write the date in a non confusing format, e.g. yyyy/mm/dd or yyyy/mm/dd<br />

</div>


Try to write the date in a non confusing format, e.g. yyyy/mm/dd or yyyy/mm/dd


<div>
I meant :yyyy/MM/dd or yyyy/MMM/dd<br />
<br />

</div>


<div>
Hi Thanks for the reply. How would I code that? 
</div>


Hi Thanks for the reply. How would I code that?

<div>
Thanks I'll try that and get back to you
</div>


<div>
Thanks That works. I made a slight change:<br />
<br />
strsql = &quot;INSERT INTO MyTable (MyDate) VALUES (#&quot; &amp;&nbsp;MonthCalendar1.SelectionSt<wbr />art.ToStri<wbr />ng(&quot;yyyy/M<wbr />M/dd&quot;) &amp;&nbsp;&quot;#)&quot;
</div>


Thanks That works. I made a slight change:

strsql = "INSERT INTO MyTable (MyDate) VALUES (#" & MonthCalendar1.SelectionStart.ToString("yyyy/MM/dd") & "#)"

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
I am having a problem with the MonthCalendar control. I have created a form which has the MonthCalendar control on it. the user then selects the required date and clicks the save button. The save button then writes this date into an Access Database field. All works fine if I pick say 25/10/2005 as a date, but when I select 02/03/2005 it saves the date as 03/02/2005 ?????<br />
<br />
Here is a snippet of the code I use.<br />
<br />
strSQL = &quot;INSERT INTO MyTable (MyDate) VALUES (#&quot; &amp;&nbsp;MonthCalendar1.SelectionSt<wbr />art &amp;&nbsp;&quot;#)&quot;<br />
<br />
then I process the strSQL <br />
<br />
Any help would be appreciated!
</div>
</div>


Hi All

I am having a problem with the MonthCalendar control. I have created a form which has the MonthCalendar control on it. the user then selects the required date and clicks the save button. The save button then writes this date into an Access Database field. All works fine if I pick say 25/10/2005 as a date, but when I select 02/03/2005 it saves the date as 03/02/2005 ?????

Here is a snippet of the code I use.

strSQL = "INSERT INTO MyTable (MyDate) VALUES (#" & MonthCalendar1.SelectionStart & "#)"

then I process the strSQL 

Any help would be appreciated!

Date Confusion

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,