Imported Time Formating

I am importing a time into a sql datetime field from a text datafile using vbscript in an asp file. The time coming in will look like 8:00 or 3:30 or some other similar thing.

Because it is doesn't have am or pm associated with it, I have to force the issue or sql will assume am all of the time, and I am sure that no judge in our county is going to hear a case in the middle of the night!

So I have to add 12 hours to anthing that could be an afternoon time before I add it to the database to keep it from looking stupid in the display screens.

View Replies


ADVERTISEMENT

Not Displaying Imported Records

I am working on exporting my results to excel and running into an issue where I wasn't getting any records but have since now been able to see some records now....it appears to only be showing records that I have added thru the web interface to the database, it's not showing the records that I imported (SQL database).

My results.asp displays all the records properly, it's just not working on my export to excel. I've looked at the data in the SQL table but I don't see anything unusual. Has anyone ever run into this before and have any clue on what I can check now?

View Replies View Related

Excel Imported In Access

I imported an excel data files with columns heading A, B, C, D, E, F in Access. However, in Access it shows up as reverse column order, F, E, D, C, B, A. Anybody knows why and what should I do to correct the order?

View Replies View Related

Formating URL's

I would like to format URLS that are being retreived from a database. Here is an example:

bodytext="this is some text http://www.sitepoint.com/ this is some more text"
response.write(bodytext)

how could I change the URL (http://www.sitepoint.com/) to a link? So instead of http://www.sitepoint.com/, it would be <a href="http://www.sitepoint.com/">http://www.sitepoint.com/</a>. There are going to be an infinate amount of URL's (the user can type in any one) and it is just not the URL by itself.

View Replies View Related

Formating Year

I want to be able to format a year as mm/dd/yy

formatdatetime does not work because the year is yyyy. How do I format a 2 digit year such as 04 for 2004?

View Replies View Related

Formating Text

When i send a text string to my database linebreaks are stored, but when i call it from asp to the page all linebreaks are lost.
this will reformat text to look different than i was initially typed, how can i make the text shown on webpage in orginal formating.
hope im clear on this or ask and i will elaborate.

View Replies View Related

Date Formating

does anyone know if there is a function to format date?When my date is extracted from database, it is in decimal format (ie.38233.72078), is there a way to convert this number to date formate using asp?

View Replies View Related

Formating Strings

I have a list of dates in a sql database that are input as varchar like this 042999

How do I insert / in between the date/month and year

so this 042999 will appear like this 04/29/99

View Replies View Related

Variable Formating

Having a pretty annoying format 'error'

The below code works fine,

strMessage = "Logged in as: " & Session("UserName") & ""

but it displays as:

Logged in as:
'Username'

Were as i want it to be:

Logged in as: 'Username'

Any ideas how to make it go to one line?

View Replies View Related

Keeping Formating

I posted before about replacing special characters (esp. '). However, I am wondering how formatting can be kept when entering it into a textbox to store in a database?

When text with seperate paragraphs is entered, it comes out as one big paragraph later on.Is there anyway to address this? When I was doing my searching - somethign about chr(10) kept coming up, but I am not sure what this is.

View Replies View Related

Formating % On An Page

I have an ASP page taking data from a table. I would like that the data is shown as a % (like 51.456897%) All it shows with my code below is 0.51456897.

Can someone tell me how to change the code so that my % is shown? ....

View Replies View Related

Formating A Number With Own Function

if we use formatnumber library function in asp it will format the no as per the number format defined in the locale of the server. For example:

some number format look like this 34,135,200 (comma seperated)
some looks like this 34 135 200(blank spaces seperated)

so does anybody have a vbscript function which do this job.

View Replies View Related

Response.write Formating

I have the following variable being displayed but i would like it displayed in the default font and text size 2 how is it done?

<% response.write(sUserId) %>

View Replies View Related

Date Function Formating

Is there a way to output a date in latin american format?

You know the day first, the month second and the year last.

View Replies View Related

Number Formating Decimal Places Not To Remove Zero 0 At The End

I have a report that will format a number to the last 2 decimal places. However it will trim off the 0 at the end. Example.

98.90 is formated to 98.9

how can i tell the format number function to not trim the 0 but still have the last 2 digits.

View Replies View Related

ASP - Date Formating MySql Insert/update

I am storing dates in a mySql database in the format yyyy-mm-dd. Now, I have set up so that this field is insert by a form.

It isn't very user friendly to have to type yyyy-mm-dd, how can I set up so that the user can enter format dd/mm/yyyy and it will automatically insert into the database as yyyy-mm-dd? I am using Dreamweaver MX 2004 and ASP.

View Replies View Related

Number Formating :: Adding Zeros In The Beginning

I have a querystring that passes through the value 001 for example, the form on the receiving page need to display that number but with 1 added to it. i have

dim strnum
strnum = request.querystring("value")
strnum = strnum + 1

when displayed <%=strnum%> shows 2 instead of 002, and the zero's are very important, is there any number formating trick i dont know or another way of doing this?i thought about coding the first two zero's in before i call the strnum but this would mess things up when i get to 010 etc.

View Replies View Related

Time Calculation :: Difference Between Login And Current Time

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.

View Replies View Related

ASP To Re-load Page From Time To Time To Reset Varaibles

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:

View Replies View Related

Comapring Database Time And Computer Date/time

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

View Replies View Related

Time/Date Format And Changing Time To GMT

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:

View Replies View Related

Time Convert String To OdbcType.Time

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 Related

Local Machine Time To Eastern Time

How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?

View Replies View Related

Time Function Returns Wrong Time

When 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. ?

View Replies View Related

How To Get Asp Execution Time And Database Connection Time ?

Any some tools or sample codes drop down asp script execute time and
database connection time ?

View Replies View Related

Server Time Local Time Convert

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.

View Replies View Related

Compare The NOW Time With A Deadline Time

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.

View Replies View Related

Time Calculation :: Between Two Dates And Time

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.

View Replies View Related

Time

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

View Replies View Related

Time

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.

View Replies View Related

Using Time

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?

View Replies View Related

Time

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 Related

Time Out

I 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?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved