Hi

I have a hidden form field which updates a date field in my database.

the default value of this field when a record is added is in english date format dd/mm/yyyy but when it updates it from the hidden form filed using <b>&lt;%= Date() %&gt;</b> it is updated in american format mm/dd/yyyy.
I am selecting DATE(MS Access) from the dropdown in the update behaviour dialogue.
How can i get it to update in english format?

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Hi Dave

Put this at the top of the page (in the code, of course)

&lt;% session.LCID = 2057 %&gt;

should do the trick, it sets a session variable for the date in UK format.

Stefan

UD4 | ASP | VBScript | ACCESS | IIS5

Thanks Stefan

I've found tho that by selecting DATE rather than DATE (MS Access) it updates in UK format anyway.

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

hi

so could this <b>&lt;% session.LCID = 2057 %&gt;</b> be put in a global.asa rather than on the pages themselves?

thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

This strikes me as strange

When I update the date whilst testing here at home it updates correctly but when updating on the remote server it still updates it in american format.
the remote server is UK based.
This is with &lt;% session.LCID = 2057 %&gt; in a global.asa

any ideas?

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Edited by - Davecl on 12 Jan 2003 07:54:25

I haven't made changes to the global.asa so don't know much about it, but... are you able to configure it on a remote server that you don't administer?

The other thing is to put the &lt;% session.LCID = 2057 %&gt; on your site's entry page, after all, once the session has been set, it will last for the duration of the visit, so no need to put it in the global.asa?

UD4 | ASP | VBScript | ACCESS | IIS5

Yes my server allows me to use global.asa but I've been reading up on this session.LCID and it seems that it only alters the way the date is displayed not the way it is entered.
I've tried every different way I can think of to update the date and it still updates it in American format, so I've taken out this part of the code for now.
The original date of the record will have to do.

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

I find that the best way to store dates is just use the default and then display it in whatever format you want, this is extra true for me because inserting a dutch format date into a access dbase can be hairy...it's easy in sql 2000, just change the login language, but with access it's a different story, study this if you want to know more about your options:
msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acdecDecideWhetherUseDisplayFormattingDataEntryMasS.asp
(make sure you read the mask link at the botton)

Hope that helps.

with regards,

Dennis van Galen
DMXzone Manager

Extension, Tutorial and FAQ's Manager

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

Thanks Dennis

I've looked at the link but the problem is not with the input masks etc.

The date is put on the record by default in Access when it creates a new record, this is fine.
The problem is when someone edits a record on the website, in the form that they use to update the record there is a hidden field with the value &lt;%= Date() %&gt; which updates the db field. It is this update that is going into the db in mm/dd/yyyy instead of dd/mm/yyyy which is the default.
I just don't understand why.

I was thinking about using this code to get the current date.

<b>strDate = Date() - &lt;%=(rsetMessages.Fields.Item("flddate".Value)%&gt;
strDate = &lt;%=(rsetMessages.Fields.Item("flddate".Value)%&gt; + strDate</b>

and then using strDate in the hidden form field to do the update, what do you think?



ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
<b>strDate = Date() - &lt;%=(rsetMessages.Fields.Item("flddate".Value)%&gt;
strDate = &lt;%=(rsetMessages.Fields.Item("flddate".Value)%&gt; + strDate</b>
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>
I am not sure that is going to return what you want, have you tried something along the lines of...

<pre id=code><font face=courier size=2 id=code>&lt;%
UKdate = DAY(Date()) &"/"& MONTH(Date()) &"/"& YEAR(Date())
%&gt;

&lt;input name="UKdate" type="hidden" value="&lt;%= UKdate%&gt;"&gt;</font id=code></pre id=code>

It's just a thought...
But do let me know if it works because it should and using this method you can create every date format you want and it works as you designed it worldwide, no matter if server is set to uk or USA or even japanese.

with regards,

Dennis van Galen
DMXzone Manager

Extension, Tutorial and FAQ's Manager

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5

Hi

Well the code I gave before was not right, I changed it to this

<b>&lt;% strDate = Date() - (rsetadmineditmess.Fields.Item("MessageDate".Value)
strDate = (rsetadmineditmess.Fields.Item("MessageDate".Value) + strDate %&gt;</b>

and it seems to work, although it's a bit untidy <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Your code seems a bit more like it, so I will try that. I'll let you know if it works.

Thanks

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Hi

Yes your code works, thanks, updating perfectly now.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Actually DAY(), MONTH() and YEAR() are SQL Server functions, but obviously ASP works with it happily and that is good because this kind of date building does not work if you use the DATEPART() function, it will return a syntax error.

Sometimes you just have to be creative to get M$ products to do what you want them to do <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

with regards,

Dennis van Galen
DMXzone Manager

Extension, Tutorial and FAQ's Manager

Studio MX / CFMX PRO / SQL 2000 / NT4 AND win2kPRO / IIS5