Form Date Field Issue

V

Van Sickle

Our team has created some forms in FrontPage 2003. When our clients submit
their forms the data filters through to a local database. In the additional
fields section of the form we've created a date column to show us when the
submission was made. The format of this date changes with every entry.
Sometimes 11-30-2008, sometimes 2008-11-30, etc...

Is there any way to ensure the date stays the same format when it arrives at
our end?
 
S

Stefan B Rusynko

Is it a user field or a hidden field
- use of a hidden form field would let you set the date to one format

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Our team has created some forms in FrontPage 2003. When our clients submit
| their forms the data filters through to a local database. In the additional
| fields section of the form we've created a date column to show us when the
| submission was made. The format of this date changes with every entry.
| Sometimes 11-30-2008, sometimes 2008-11-30, etc...
|
| Is there any way to ensure the date stays the same format when it arrives at
| our end?
 
V

Van Sickle

Thanks for your help Stefan...

The team is actually using the "Timestamp" option in the "Options for Saving
Results to Database" menu.

The intent is to time/ date stamp each form that is submitted by our user
group. Each submission results in a different date format.

Is there a better way to accomplish this?
 
S

Stefan B Rusynko

If it is a html page,
- setting your html page local language/lcid should control the date format
- or you can get a current date with JavaScript code and use that in a hidden form field

With a server side script form page (.asp) you could just enter a formatted date in the hidden form field value using say
<% = Month(Date()) & "/" & Day(Date()) & "/" & Year(Date()) %>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Thanks for your help Stefan...
|
| The team is actually using the "Timestamp" option in the "Options for Saving
| Results to Database" menu.
|
| The intent is to time/ date stamp each form that is submitted by our user
| group. Each submission results in a different date format.
|
| Is there a better way to accomplish this?
|
| "Stefan B Rusynko" wrote:
|
| > Is it a user field or a hidden field
| > - use of a hidden form field would let you set the date to one format
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Our team has created some forms in FrontPage 2003. When our clients submit
| > | their forms the data filters through to a local database. In the additional
| > | fields section of the form we've created a date column to show us when the
| > | submission was made. The format of this date changes with every entry.
| > | Sometimes 11-30-2008, sometimes 2008-11-30, etc...
| > |
| > | Is there any way to ensure the date stays the same format when it arrives at
| > | our end?
| >
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top