logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > ASP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 10-18-2007, 11:03 AM   #1
Emstrur
Emstrur's Avatar
 
Join Date: Oct 2007
Location: Iceland
Posts: 2
Smile Date format

Hi
I am about to deliver a website with an Access database connection. Everything is working great except the date format. Originally when I set up the data table I used the default format for date/time in Access. After I made the connection in Dreamweaver I intended to highlight the date field and define the date form by going through Application/Format, which I did. Unfortunately nothing happens and no matter what I define I always get this format for the date: 15.10.2007 08:57:54. For this particular website this is a bit to much of a detail.
Does anyone have a solution?
Einar
Emstrur is offline   Reply With Quote
Old 10-18-2007, 08:32 PM   #2
davidj
davidj's Avatar
 
Join Date: Sep 2005
Location: The Toon (newcastle upon Tyne)
Posts: 8,256
Default

what that is is a date time stamp

try changing the field type from date / time stamp to date unless you want to retain that format in the db

in php there is a number of different option i have like using a substring function or an explode but im not sure what you have available in ASP
__________________
Would you like to learn PHP from me? Check out -> www.codezenith.co.uk
davidj is offline   Reply With Quote
Old 10-19-2007, 11:12 AM   #3
Emstrur
Emstrur's Avatar
 
Join Date: Oct 2007
Location: Iceland
Posts: 2
Question Date again

Thank you for your reply davidj

In Access when you define the Data Type for the field in the table, you only have the Date/Time option. There is no separate Date or Time option. On the other hand you can choose a Format for the Date/Time option. You can actually choose from seven options. In my database I selected a date format only, no time format.
What bothers me is a complete lack of response from Dreamweaver. The software simply doesn’t respond to any of the options, but delivers the same number sequence again.
So I was hoping someone would have an answer here in the club, either to hand code or a DW solution.
Best regards
Einar
Emstrur is offline   Reply With Quote
Old 01-27-2008, 02:06 AM   #4
mangofreak
mangofreak's Avatar
 
Join Date: Jan 2006
Location: Toronto-Canada
Posts: 444
Default

What about changing your DB field to text instead of date and make sure you show the date on your script. I personally do that, also in case you want to upsize to MS SQL.

Code:
<% 
Dim sDate
sDate = "1/1/2008"

Response.Write sDate
%>
<br />

<%= Response.write (FormatDateTime(sDate,1))%>
If does not apply to your problem. Please disregard.

J.
mangofreak is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:17 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com