Timestamp Date Format

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Timestamp Date Format

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> Server Issues >> Timestamp Date Format

Page: [1]


Colin Williams Posts: 13 Joined: 9/6/2002 Status: offline	Timestamp Date Format - 9/11/2002 12:11:05 I' ve created a form in FP2000 that posts data (including the Timestamp field) into a database created via FP. As I am in the UK, my computer is set to UK date format (dd/mm/yy), as is the server that is hosting my web. Despite this, the FP form insists on posting the Timestamp date into the database in US format (mm/dd/yy). Does anyone know where I need to start looking in the Extensions set-up to correct this? It is causing much wailing and gnashing of teeth in the office as the database believes today is 9th October (09/10/02) and tomorrow will be 9th November (09/11/02) etc. which obviously plays havoc with the information i can get out of it. CW


Spooky Posts: 26606 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Timestamp Date Format - 9/12/2002 23:31:43 I would think that somewhere in the default code, FP is changing the LCID The default is US Session.LCID = 1033 Heres a some info on locale identifiers : http://msdn.microsoft.com/library/default.asp?url=/library/en-us/intl/nls_2jzn.asp Heres some info on how to change it : http://www.4guysfromrolla.com/webtech/tips/t022202-1.shtml The default setting for the DRW is contained in the _fpclass/fpdlib.inc file in the FP_SetLocaleForPage function, but I cant locate the original setting of this variable. _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to Colin Williams)


Colin Williams Posts: 13 Joined: 9/6/2002 Status: offline	RE: RE: Timestamp Date Format - 9/14/2002 4:04:08 Thanks for the links, but jeez this stuff looks complex. I' m a designer, not a programmer, that' s why i try to let FP do all the programming stuff for me. Seems a bit daft that half the western world can' t post a form with the correct date in it! CW (in reply to Spooky)

Page: [1]

All Forums >> Web Development >> Server Issues >> Timestamp Date Format

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts