I am trying to create a form where the user chooses a country from a drop down menu and chooses a UK time (not necessarily current time) from another drop down menu then submits.
I want the output to show what the time chosen in the UK will be in the selected country.Sound straightforward but I am having problems with the time format and how to add and subtract times.
I have an ASP page which is pulling a date out of an SQL database and displaying it in a textbox. The database field format is smalldatetime and in the table the date looks like DD/MM/YYYY. However, when I pull it out and display it on the ASP page it appears as DD/MM/YY. I need the year to be YYYY. I have tried using the formatdatetime function to get this format but I still get the YY format.
How can I change it? I need it to remain in date format (rather than a text string) so that I can reinsert it later.
I am storing dates in an access db in uk format dd/mm/yy I wish to display these in this format, but in order return records BETWEEN two dates it needs to be in mm/dd/yy.
View Replies View RelatedI'm working on converting some data from an old .dbf file and I'm having problems with the date fields. These are example values from date related fields.
1127431141
1134688741
1128650845
I've read about Julian type dates, but this doesn't fit the format. Any ideas what format these dates are in and how to convert to something more usables (mm/dd/yyyy)?
i am working with uk date formats (dd/mm/yy) however the server the site is hosted on is in the us(mm/dd/yy) format . i am using the following to convert the ddates
gigdateuk = day(rs1("Date")) & "/" & month(rs1("Date")) & "/" &
year(rs1("Date"))%>
Response.Write gigdateuk
this works ok. however i am building a page that allows the record to be edited or a new
one added. how do i convert this back to us(mm/dd/yy) format when i post the form.
I am displaying some information from a database on an ASP page. I have a date field in the database but when this information is displayed on the ASP page the date format is MM/DD/YY. I need it to be DD/MM/YY. How would I do this with ASP? Why does it display in this format when I have it in the correct format in my database and the server is set to UK time?
View Replies View RelatedI have my access database with a Yes / No field.. When thats loaded into the asp page, it shows as a true or false. How can I change this back to either yes / no or tick box?
View Replies View RelatedI dont suppose anybody knows of any asp code that can determine the format of a file i.e ASCII or Unicode , in the context of a function that will return a boolean value of true if the file is in ascii format and false otherwise or vice versa
View Replies View RelatedThe data for our bookings is held in an Access database and I can
manipulate the date format as much as I like in Access but it doesn't make
any difference to what appears in my webpage. Code:
I have a text area, similar to the one i am using to write this message, and i want to have the font toolbar like the one in Microsoft word as well as the one used here which allowes the user to select font styles, size, bullet points etc.
I am using web tandards so have several style sheets already so was wondering if i would have to go about it this way or would i use some sort of scripting language like Javascript. Not sure which way i am meant to use as this is the first time i have ever needed to creat such a feature.
It is switching between American and European date formats - this is causing problems on the page which use the Date function. Most of the time the page works ok but sometimes it seems to switch formats and this messes up the code on the page.
I have spoke with the people who look after the servers on which the site runs but do not know what is causing this. They have not made any changes to the date format of these machines. The website and the database are kept on different servers. Has anyone came across this problem.
I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something
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 am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.
View Replies View RelatedHow will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?
View Replies View RelatedWhen the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.
I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?
Any some tools or sample codes drop down asp script execute time and
database connection time ?
I'm trying to do a very simple code that converts the server time into a time zone of your choice.
<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>
but obvisouly i'm having trouble with the time zone convert.
I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.
CODE:
nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if
RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today
As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.
i want to calculate the total time between to dates and time.
Example: Total time elapsed from date 1 time 1 to date 2 time 2.
27/09/2004 11:00 - 28/09/2004 10:30
The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.
i am trying to get a time variable which is 30 minutes before the current time to use in a calculation.
The code I am using is:
validationtime=time-3000
response.write(time)
response.write ("<BR>")
response.write(validationtime)
but the response I get is incorrect along the lines of:
11:54:42
14/10/1891 12:05:18
What am I doing wrong, why is validation time also including a date
Can someone tell me how i can use a if loop
its related with time I want to display a registration form on 29 Jan 2007
only between 10am pacific time to 1pm pacific time
so only between 10am - 1pm pacific time the registration form should appear
i live in the central time zone
can someone tell me how i can make this happen.
I am trying to use the time function to determine whether or not it is morning, afternoon or evening.
I wrote my code and then changed the values it is comparing with to see if would work and it doesn't, it just stays on the good morning.
<% if time > 0 then %>
Good Morning <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>
<% if time > 12 then %>
Good Afternoon <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>
<% if time > 18 then %>
Good Evening <b><%= Session("sessFirstName") %></b><br><br>
<a href="logout.asp">Log Out</a>
<% end if %>
Do i need to put quotes around the number i am checking with?
how can i get this tag to adjust for time zones? This is probably simple, but i just can't think of how to do it. Code: <%=Time%>
View Replies View RelatedI am writing an XML file with lots of Data and it takes time but before the operation can be finished I get this error
Quote:
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.
How do I handle this?
Would anyone know if there is an easy and clean way of presenting maybe a time control field in html in an .asp page that allows a user to specify a certain time of the day? Currently using an <input name="SpecifyTime" type="Text"field but was wondering if there was a better way of doing this as to where users won't mistype in entering non time related characters?
View Replies View RelatedWould it be a stupid idea to use the Log Util component to retrieve the UTC date/time? It appears that the DateTime property could be used for this, but I'm not really sure how it searches through the log file.
View Replies View RelatedI've used this ASP funtion to display the time on my web page:
Date: <%= FormatDateTime(Date, 1)%>
Time: <%= FormatDateTime(now, 4)%>
THis was working fine until i moved my site to a server based in the states, not the time is 5hrs behind. help me resolve this?
I am using ADO to connect to SQL 7.0. At times the connection timeout expires. Is there any way to inrease the default time out? I think currently its 60 secs. Here is the code that I use to establish ADO connection.
set rs = Server.CreateObject("ADODB.RecordSet")
sCon = "DRIVER={SQL Server};
SERVER=Indy2;DATABASE=ProdProtrans;UID=xx; PWD=xxxxxxx"
How to find GMT time in ASP?
View Replies View Relatedi have two rows in data base with similar data except the time coloumn , the time coloumn is the only one with differnt times ex: 08:00am in one row and 9:00am , form the sql query when i taken the results where name='"&name&"' themn i am getting only one name . how can i compare the time with system time and get them login accordingly.
View Replies View Related