I try to display the time from an access db in 12hr clock format. Am I missing something simple? The time is held in the medium date format ie 07.30pm and I'm using:
FormatDateTime(rs("StartTime"), vbshorttime)
but this displays 19:30 instead of 7:30. If I change to vblongtime I get 19:30:00 and if I change the time field format to short time I still get 19:30. What am I doing wrong??!
I am using the query bellow to display some fielsd on my page and am having some problema displaying the data from calltime. I have the field setup in access as short time but when it is displayed on the page it displays as 12:15 AM. How can I remove the AM/PM from the display?
<% notesSQL = "Select * From notes where callID =" &RSupdate("callID")
Set RScalls = dbConnection.Execute(notesSQL)
Do While Not RScalls.EOF
callscounter=callscounter+1
%>
<%=rscalls("notes")%> Added by: <%=rscalls("employee")%> on
<%=rscalls("notesdate")%> Time Spent: <%= rscalls("calltime") %><br>
I have two Win2K machines. Both "appear" to have been set up identically.
They both reckon that they're using UK date format.
However, if I create the following ASP code:
<%
Response.Write Now
%>
One returns
16/01/2004 17:12:19
Which is what I want, whilst the other returns:
1/16/2004 5:15:21 PM
Here, the day and month have been transposed and the time appears in the 12 hour clock format.
Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:
"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"
Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:
I have and XSL page that transforms my XML data from MSSQL. The way I display datetime variable from XML within XSLT is:
<xsl:value-of select="ms:format-time(Modified, 'h:mm tt')" />
Which is fine, except it gives me time in UCT, when I need it in Eastern (-5 GMT) time.
XML actually has the correct data and it shows -5, but XSLT will only display UCT. How can I fix that?
Working in VBScript ASP page with MSAccess Db. Well I'm darn embarrased for this to be my first post on here - you know when you've solved all the big stuff and then some tiny stupid little thing sends you flat opn your face ?
I want to put a time into my sql statement, like this :
INSERT INTO hoursTbl (opening,closing) VALUES ('09:15','17:35')
or
#09:15#,#17:35#
or
#9:15:00#,#17:35:00#
etc etc....
nearly all of them work if I run them in Access itself, but none are working in my ASP page. I get the standard 'syntax error in INSERT statement' error message
Is it a special syntax I need?
I'm using an Access db and have a field which holds the time of an event. The field is a text type as when I chose date/time format when displaying it on my ASP I couldn't format it. So anyway, I display my date like so
strStartTime = rs("StartTime)
FormatDateTime(strStartTime, vbshorttime)
which formats the time in a 24hr format but I want to display am/pm, how do I do that?
I've made my own guestbook in asp and everythink is working fine. The page is hosted on a server located at USA and the record time is displayed with AM and PM... How can I put it like 16:00 for example?
View Replies View RelatedI am trying to get a time to display with AM or PM (not the 24 hour clock). When I use:
Code:
<%=FormatDateTime(Now(), vbLongTime)%>
I get 21:28:37 I want 9:28 PM .
I'm trying to us the formatdatetime function to format US-time and it doesnt give me the seconds. how to do that?
2002-02-02 06:00 AM gives 6:00 AM when I want 6:00:00 AM
When pulling the hour (or minute, or second, or day, or month, etc) from
the server like:
<%= hour(time) %>
Is there a quick way (like, without an if then statement to check it and
fix it) to format it so it represents all hours in two digits like:
00
for 12 am. instead of just:
0
?
I am trying to format the following line fo code so that it shows tha date time in my database as dd mm yyyy
currently in the database it shows as 2006-10-03 08:01:00
Here is the code that I want to format it is posssible to format it in such a way???
Response.Write "<td class=TableFieldInput>" &trim(rsSet("Archive_date")) &"</td>"
i am using ms access for my database.there is a table named Reservation and of the field inside this table is resDate which is the format is Date/Time.in my asp page (use vbscript), there is a variable where i coded it like this, res_Date = Date().the save data process is just fine but when i look into the data database, my resDate stored data just like this 12:00:00 AM.but when i try display res_Date at asp page, it shows the current data like 12/7/2004.is there any wrong with my code or i just left something?
View Replies View RelatedI trying to do a start date/time and end date/time data from database to performance check it is overdue from an asp file.
So I have Start Date/Time and End Date/Time form textfields. The time textfield is 24hour format. The date are 3 fields Day,month and Year. Code:
I have this field time field in my database which has records in the military format
example:
203454
83452
113434
211413
Can anyone tell me how to come up with a slick function to show results in the normal time format
I'm trying to format 5/23/2005 9:00:00 AM to look like 20050523T140000. How can this be done with ASP? I have a VB version, but ASP uses FormatDateTime and I saw no equivilent switches.
View Replies View RelatedI have a simple calendar scipt that ask for time of event input. While I like the time feature I do not like the fact that it displays with seconds included.
Ex. Displays HR:MIN:SEC 5:05:30 PM
Desired display 5:05 PM
How do I get rid of the display showing seconds? I have changed the database format, but this does not seem to effect the disply on the asp page.
I've looked over the last 2000 posts for info on incorportating an RSS feed on a web page using ASP to control the display - especially which elements are shown and how many items are shown. I found a free ASP script that I hoped would do the job >>>
View Replies View RelatedI want date inputs to be in the form "d-m-yyy h:m:s". On submitting a form. I want any date input not i this format to be alerted for the correct format.
View Replies View RelatedI have a variable that contains a time value in the format HH:MM:SS that indicates a duration rather than a clock time, and I need to convert it to plain seconds so an input of "00:07:01" would output "421". I'm not too good with time/date conversions, and I can't seem to get this one working right. Is there anyone out there that already has a script that does this or someone who could point me in the right direction?
View Replies View Relatedi use this code to convert the date format throw asp. so it could work well with me sql server Db Code:
strSQL="select * from Visit where convert(datetime,visitdate,103) = convert(datetime,'" & date() &"',103) ORDER BY visittime"
rs.Open strSql
but u try to convert the tme form also in the same way but it doesnt work , so anybody have any idea how could this be done? Code:
In backend access table, I have set date format as medium date i.e. 15/Nov/2007 but in ASP output it shows as 11/15/2007. Can it be displayed as 15/Nov/2007? Also there is a hyperlink .. Code:
<a href="mailto:<%=rsProject("ClientEmailID")%>&mailccto:<%=rsProject("UMLEmailID")%>?Subject=<%=rsProject("Subject")%>">Click Here</a>
But it does not work properly and gives only to output, not CC or subject. I want to make a mailto link which can have to, cc, subject and if possible mail body also.
I currently have a .asp web (using VBScript) that retrieve the date field from my Access database. The format stored in my database is in DD-MMM-YY format.
But when i display it onto the web, it is in MM/DD/YY format. May i know if there is any way i can change the format that i display to DD-MMM-YY , or to a DD-MM-YY format?
i have a form value which accepts the date format in the dd/mm/yyyy Code:
View Replies View RelatedI have a DateTime stamp in one of my Access database columns. Using now() as the default value, it enters records in the following format:
17/06/2005 14:28:40
This is perfect. UK format, just as I want.
However, when I pull this record into an ASP page it appears in a different format:
6/17/2005 14:28:40 AM
How can I stop it from re-writing the data into American format? I just need to display it exactly as it is in the database.
I will be eternally greatful if someone can provide snippet of code,
URL or reference material that shows how to display data in a "n
colums * n rows" format.
I am new to ASP and have looked everywhere that I could, but I have
not found an example where data can be formatted to be displayed in a
3 * 4 foramt, like many of the professional sites would do (actually
rows and columns can be any number of rows and columns) All the
examples that I have seen, show data displayed in a top down format.
I have this is my code:
<%= linkRec("datein")%>
It displays the date like this: 12/14/2004
But I need it to display like: Dec 14, 2004 or something similar (not just numbers)
Is this possible?
Can anyone guide on function to display the remaining time left once i login when i set a Server.ScriptTimeout.
View Replies View RelatedBasically, what i want to do is select all records that match a value (1 for instance) in a feild(userID), then Display Only 3 in its own column on a table row on the page, then create another row and display the next 3 records in the same format from the same select query.
i think its got to be somehow possible with a For statement, but i cant think what.
Is it Possible to this and if so how?
how to display correct time according to user timezone. i want to do an online meeting
example: let say schedule meeting at 1:00pm server time, how do i display the correct time for users in their local time are there any tutorials to do this.
I am using the function <%=time %> but want to know if there is a way to display the current time + 20 minutes?
View Replies View RelatedI have set up an Access database with a couple of time fields. These display within the database columns as hh:mm but when used to populate my web page show up as hh:mm:ss.
What ASP code can i use to remove the seconds and show these times in the format hh:mm?
Been looking around the web and found some examples but nothing great. wondering if any1 here has seen a script to show a dynamic clock on a webpage that displays server time (this will be for an intranet app). me and my budy have been working on different ideas but to no avail. so in the mean time thought id post to see if any1 has seen 1 or has done one.
View Replies View Related