<div>
you can use the <a href="http://http://www.w3schools.com/asp/func_formatdatetime.asp" rel="ugc">FormatDateTime function</a>, but that'll still give a for character year, so maybe a custom function would be better:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41794125-1"><span>function customFormatDate( d )</span>
<span>     customFormatDate = padZero( Day( d ) &amp; &quot;/&quot; &amp; padZero( Month( d ) &amp; &quot;/&quot; &amp; Right( padZero( Year( d ), 2 )</span>
<span>end function</span>
</code></pre>
<br />
and you would call it like:<br />
<br />
Response.Write customFormateDate( now )
</div>


<div>
4 character year is fine for me, FormatDateTime ill try out and get back to you<br />
<br />
cheers
</div>


<div>
ok, it should work the way you want to as long as your server date format settings are dd/mm/yyyy.<br />
<br />
example:<br />
<br />
Response.Write FormatDateTime( now, 2 )
</div>


<div>
Just looking at FormatDateTime here: <a href="http://www.w3schools.com/asp/func_formatdatetime.asp" rel="ugc">http://www.w3schools.com/a<wbr />sp/func_fo<wbr />rmatdateti<wbr />me.asp</a><br />
<br />
not seeing dd / mm / yyyy ??<br />
<br />
I only see mm / dd / yyyy
</div>


<div>
I believe the format is based off of your local servers date/time locale settings. Give it a shot and see what happens!
</div>


<div>
Still does the same<br />
<br />
would I have to put it on the Response.Write ? or the Executed Query? or both?<br />
<br />
I currently have it on the Executed Query
</div>


<div>
also tried putting it on the Response.Write, same thing too
</div>


<div>
I would set it as its own variable, then use that in your query.<br />
<br />
Did you try the custom function I gave you?
</div>


<div>
would it matter with the date...<br />
<br />
&lt;input type=text&gt; put in the there and submitted, when you go back to update it, that is when it changes, and you can keep clicking update and it changes around
</div>


<div>
can you post your updated code?
</div>


<div>
<pre><code class="code-1 nolinks" id="code-20-41794346-1"><span>oConn.Execute(&quot;UPDATE events SET event_name='&quot;&amp;Request.Form(&quot;eventname&quot;)&amp;&quot;',event_start=#&quot;&amp;FormatDateTime(Request.Form(&quot;eventstart&quot;),2)&amp;&quot;#,event_finish=#&quot;&amp;FormatDateTime(Request.Form(&quot;eventfinish&quot;),2)&amp;&quot;#,event_location=&quot;&amp;GPLocations(&quot;location_ID&quot;)&amp;&quot;,event_code='&quot;&amp;Request.Form(&quot;codeID&quot;)&amp;&quot;',event_conf=&quot;&amp;EventConf&amp;&quot;,event_live=&quot;&amp;EventLive&amp;&quot; WHERE event_ID=&quot;&amp;Request.QueryString(&quot;event&quot;))</span>
</code></pre>
</div>


<div>
if you do:<br />
<br />
Response.Write &quot;UPDATE events SET event_name='&quot;&amp;Request.Form<wbr />(&quot;eventnam<wbr />e&quot;)&amp;&quot;',eve<wbr />nt_start=#<wbr />&quot;&amp;FormatDa<wbr />teTime(Req<wbr />uest.Form(<wbr />&quot;eventstar<wbr />t&quot;),2)&amp;&quot;#,<wbr />event_fini<wbr />sh=#&quot;&amp;Form<wbr />atDateTime<wbr />(Request.F<wbr />orm(&quot;event<wbr />finish&quot;),2<wbr />)&amp;&quot;#,event<wbr />_location=<wbr />&quot;&amp;GPLocati<wbr />ons(&quot;locat<wbr />ion_ID&quot;)&amp;&quot;<wbr />,event_cod<wbr />e='&quot;&amp;Reque<wbr />st.Form(&quot;c<wbr />odeID&quot;)&amp;&quot;'<wbr />,event_con<wbr />f=&quot;&amp;EventC<wbr />onf&amp;&quot;,even<wbr />t_live=&quot;&amp;E<wbr />ventLive&amp;&quot;<wbr /> WHERE event_ID=&quot;&amp;Request.QuerySt<wbr />ring(&quot;even<wbr />t&quot;))<br />
<br />
then, whatever is outputted to the screen, run directly in your database and see if you get any results
</div>


<div>
have been running it in my database, however because it is an UPDATE query, it doesnt produce a result?<br />
<br />
however when it updates the DB, it changes it back and forth from 1/10/2017 to 10/1/2017 and vv
</div>


<div>
even when using my custom function?<br />
<br />
oConn.Execute(&quot;UPDATE events SET event_name='&quot;&amp;Request.Form<wbr />(&quot;eventnam<wbr />e&quot;)&amp;&quot;',eve<wbr />nt_start=#<wbr />&quot;&amp;customFo<wbr />rmatDate(R<wbr />equest.For<wbr />m(&quot;eventst<wbr />art&quot;))&amp;&quot;#,<wbr />event_fini<wbr />sh=#&quot;&amp;cust<wbr />omFormatDa<wbr />te(Request<wbr />.Form(&quot;eve<wbr />ntfinish&quot;)<wbr />)&amp;&quot;#,event<wbr />_location=<wbr />&quot;&amp;GPLocati<wbr />ons(&quot;locat<wbr />ion_ID&quot;)&amp;&quot;<wbr />,event_cod<wbr />e='&quot;&amp;Reque<wbr />st.Form(&quot;c<wbr />odeID&quot;)&amp;&quot;'<wbr />,event_con<wbr />f=&quot;&amp;EventC<wbr />onf&amp;&quot;,even<wbr />t_live=&quot;&amp;E<wbr />ventLive&amp;&quot;<wbr /> WHERE event_ID=&quot;&amp;Request.QuerySt<wbr />ring(&quot;even<wbr />t&quot;))
</div>


<div>
going to try the custom function now
</div>


<div>
It should read using Format:<br />

<pre><code class="code-1 nolinks" id="code-20-41794626-1"><span>oConn.Execute(&quot;UPDATE events SET event_name='&quot;&amp;Request.Form(&quot;eventname&quot;)&amp;&quot;',event_start=#&quot;&amp;Format(Request.Form(&quot;eventstart&quot;),&quot;yyyy\/mm\/dd&quot;)&amp;&quot;#,event_finish=#&quot;&amp;Format(Request.Form(&quot;eventfinish&quot;),&quot;yyyy\/mm\/dd&quot;)&amp;&quot;#,event_location=&quot;&amp;GPLocations(&quot;location_ID&quot;)&amp;&quot;,event_code='&quot;&amp;Request.Form(&quot;codeID&quot;)&amp;&quot;',event_conf=&quot;&amp;EventConf&amp;&quot;,event_live=&quot;&amp;EventLive&amp;&quot; WHERE event_ID=&quot;&amp;Request.QueryString(&quot;event&quot;))</span>
</code></pre>
/gustav
</div>


<div>
Hi Gustav, this will insert the date as dd / mm / yyyy ?
</div>


<div>
Format() won't work, it's a visual basic function, not vbscript. <br />
<br />
To answer your previous question, you should surround the date with pound signs
</div>


<div>
Ah ok, I know I have a couple of other statements with the single quotes, but they are INSERTS
</div>


<div>
Well, what do you see?<br />
<br />
I don't know what you read from the form. You may have to apply DateValue as well:<br />
<br />
&nbsp; &nbsp; event_finish=#&quot;&amp;Format(Dat<wbr />eValue(Req<wbr />uest.Form(<wbr />&quot;eventfini<wbr />sh&quot;)),&quot;yyy<wbr />y\/mm\/dd&quot;<wbr />)&amp;&quot;#,<br />
<br />
/gustav
</div>


<div>
again, there is no FORMAT() function in classic asp, you need to use formatDateTime(), as I suggested earlier. or use the custom function I gave you.<br />
<br />
Did you try that? what were your results? I can't help you if you don't respond to the questions/solutions I propose
</div>


<div>
Hi BigMonty, sorry I was trying to figure out where the missing brackets went, got that sorted.<br />
<br />
Error now:<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-41794742-1"><span>Microsoft VBScript runtime error '800a000d'</span>
<span></span>
<span>Type mismatch: 'padZero'</span>
<span></span>
<span>/admin2.asp, line 9 -&gt; customFormatDate = padZero( Day( d ) )&amp; &quot;/&quot; &amp; padZero( Month( d ) )&amp; &quot;/&quot; &amp; Right( padZero( Year( d ), 2 ))</span>
</code></pre>
</div>


<div>
dd this function anywhere on your page:<br />
<br />
&nbsp; &nbsp; function padZero( n )<br />
&nbsp; &nbsp; &nbsp; &nbsp; if CInt( n ) &lt;&nbsp;n then<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; padZero = &quot;0&quot; &amp;&nbsp;n<br />
&nbsp; &nbsp; &nbsp; &nbsp; else<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; padZero = n<br />
&nbsp; &nbsp; &nbsp; &nbsp; end if<br />
&nbsp; &nbsp; end function
</div>


<div>
I have just tried replacing # with quotes and it inserts and doesn't change on recall and update... its working... ? is this supposed to happen? with quote and not # ?
</div>


<div>
the best way to tell if it's working is to see if the data is there in the database and in the format you want :)
</div>


<div>
yeah its all working great, no issues at all<br />
<br />
why would there be a difference?
</div>


<div>
not sure why, both formats should have worked
</div>


<div>
Interesting... how do we close off this question now?<br />
<br />
I mean you have been a help is debugging it and trying different stuff...
</div>


<div>
i can't tell you how to close a question, I think EE may object to that :)<br />
<br />
if any of my answers helped you and you think they may be useful to others, then select them. if not, delete the question and it'll auto-delete in 4 days.<br />
<br />
FYI - I'm not here for the points, so as long as you got the solution, I don't care how :)
</div>


<div>
tried something not suggested and worked
</div>


<div>
<div class="content wysiwyg-content">
Hi all, just wondering how I get the date to stay in the same format, no default<br />
<br />
dd / mm / yy - this is the format I want to use<br />
<br />
using ASP Classic and MS Access 2003<br />
<br />
example date: 1/10/17<br />
-everytime i update this is changes from 1/10/17 to 10/1/17 and then back.
</div>
</div>


Hi all, just wondering how I get the date to stay in the same format, no default

dd / mm / yy - this is the format I want to use

using ASP Classic and MS Access 2003

example date: 1/10/17
-everytime i update this is changes from 1/10/17 to 10/1/17 and then back.

How to get a date to stay the right format

Active Server Pages (ASP) is Microsoft’s first server-side engine for dynamic web pages. ASP’s support of the Component Object Model (COM) enables it to access and use compiled libraries such as DLLs. It has been superseded by ASP.NET, but will be supported by Internet Information Services (IIS) through at least 2022.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.