I am trying to insert the date into a *.csv file using the following line
csvBody = csvBody & "" & fix(FormatDateTime(now(), vblongdate) & ""
The fix function is as follows
function fix(strInput)
strInput = replace(strInput, """", "")
strInput = replace(strInput, vbNewLine, " ")
fix = strInput
end function
I would like the Date to appear as Wednesday 16th June 2005 within a single cell (without commas).
I have a form that I submit to an oracle database. Along with the info from the form I want to insert the date it was submitted. How should I go about doing this? I am having problems because it is the wrong format?
I am using a 'date' data type for the field. How can I convert the date into the correct format that will allow me to submit it, I have tried using to_char or to_date, but they give me an error?I tried using this to convert it, but it doesn't work, I am getting a syntax error?submit_date=to_date(date,'YYYY-MM-DD')
i m reading data from a excel file and inserting its fields into access database, everything is fine but i m getting problem when i m insertin the data string into the date/time field of the aceess database,i have use the CDate function but it is not working.what should i do?
View Replies View RelatedI am trying to insert a date into a date field through my website. The date
is pre-populated with todays date. I am getting a type mismatch error. The
Access DB is setup as a Date/Time Short Date field. Code:
i need to insert the date only into date/time field in sql server 2000. i tried this
Code:
newsdate=date()
insql= "insert into news(news_date) values( "&newsdate&" )"
ADO.execute(insql)
but it always insert the date 01/01/1900. i searched the net and found this.
Code:
newsdate=date()
theloc = SetLocale(ado.Properties("locale identifier" ))
insql= "insert into news(news_date) values( "&newsdate&" )"
ADO.execute(insql)
SetLocale(theloc)
i found a different way to insert the date or rather not insert the date at all if a certain condition is true. But anyway i have come accross the same problem when i try to update the date field with a blank value. Code:
View Replies View Relatedi have a field which accepts the date as dd/mm/yyyy but when i insert the value it becomes mm/dd/yyyy for some date values like 9 april become 4 august.... the database date format is mm/dd/yyyy and i just take the value out and display it as dd/mm/yyyy.. however ...
my update and inserts can't use the same function, cos the function is just display out the server's date as dd/mm/yyyy... how should i add i in correctly?
here's my insert and update function[img]images/smilies/bawling.gif[/img]
PHP Code:
Dim ddate, ydate, mdateFunction FormatDateDM2MD(sdate) if sdate="" or sdate=" " thenFormatDateDM2MD = "NULL"elseddate=day(sdate)mdate=month(sdate)ydate=year(sdate)sdate= ydate & "/" & mdate & "/" & ddateFormatDateDM2MD = "'"&sdate&"'"end ifEnd Function
i have another problem my date values when its 10 of Nov it comes out as 11/10/2003 instead of 10/11/2003 why? how do i solve it? Code:
i have a field which accepts the date as dd/mm/yyyy but when i insert the value it becomes mm/dd/yyyy for some date values like 9 april become 4 august.... the database date format is mm/dd/yyyy and i just take the value out and display it as dd/mm/yyyy..
however ... my update and inserts can't use the same function, cos the function is just display out the server's date as dd/mm/yyyy... how should i add i in correctly? Code:
this is the code im trying to use to insert a date to mysql db:
dim myquery
dim datew
datew = formatdatetime(date())
myquery = "INSERT INTO article (date) VALUES ('" & datew & "')"
this inserts a date but its always "0000-00-00", i want to get the actual date and add it to the table.
I'm trying to insert a date value into MSSQL, the type of the sql filed
is: "smalldatetime" and i'm trying to insert a text Variable that looks like this:
"19/02/2006".
.... SET update_date='" & Update_Date & "' ...
i get the message:
The conversion of char data type to smalldatetime data type resulted in
an out-of-range smalldatetime value
I'm trying to take a date from a form and insert it into an Access 2000 database with ASP
Here's the code:
frmClubId = Request.Form("Names")
frmDate = Request.Form("Date")
sqlStatement = "INSERT INTO testDates(ClubId,Date) VALUES(" & frmClubId & ", #" & frmDate & "#)"
Set rs = conn.Execute(sqlStatement)
I've already Response.Write the sql, so I know that frmClubId is and integer and frmDate is mm/dd/yyyy.
I have two ASP statements (<% , %>) that I would like to insert into one ASP file. One of the statements is already inserted in the file and works successfully.
However, when I insert the second ASP statement, the page comes up with an error;-
"Microsoft VBScript compilation error '800a0411'
Name redefined "
I am pretty sure I get this error because both statements are conflicting with one another.
I also can't combine the two statements as I use a DSN connection for one, and a DSN-less connection for another and I connect to 2 different databases.
How might I be able to include both ASP statements within the single ASP file?
A user on another Forum said " there is a variable DIMmed twice.
easiest way is a third include with the variable names in. That way it can be used with any combination of the includes."
I have to read from a csv file (; delimited) and insert it into an oracle table using asp. the file can be anywhere in the local. so is it possible to use a form and get the file name or the location as an argument. Also how do i do the insert in the existing table. Code:
View Replies View RelatedI am trying to build a asp page where signature bitmap file needs to be
inserted from a directory. The path of the file location is in one of the
backend Access database fields. I would like to know if there is any
knowledge based article related to this kind of issues. I have no idea where
to start on this.
I would like to know if there are any tutorials out there or websites that can explain more about this? can this be done in asp?
View Replies View RelatedI am uploading a file using ASP code. After the user uploads the file, I would like to be able to open the file and check if the data is in a given format (comma separated) and also has all the data elements needed (i.e. all fields are there).
Is there a parse routine in asp that would allow me to do this. The user can upload any type of file as long as I am able to parse it and determine if the data is of the aforemention type.
how to replace carriage return upon extracting text from Access file.
However I think it will be smarter to do it before (during) inserting text into acess file.
It might be primitive question, but I started my ASP learning just last week and many things are confusing me on this stage.
QUESTION:
What should I change in my ASP file code (file inserted data from the HTML form file into database file) to replace all carriage returns and line brakes during inserting text into field GuestSory? Code:
I am trying to access the date last modified of file. The problem that i am facing is that i need to make this file dynamic.This file will be the footer of any file and it needs to display the date modified of the file it is a footer of.i need to read the name of the file and then diaplay its modified date.
Following is the code I am using.....
I need to figure out if this file is over a day (or however many hours) and if it is, i need to delete it. If its not i redirect the user to it
Code:
If (fs.FileExists(workFile))=true Then
set f=fs.GetFile(workFile)
If (f.DateLastModified > Date-1)
Response.Redirect "/" & tFileName & "/" & reqString & ".html"
Else
f.Delete
End If
set f=nothing
End If
obviosuly the date-1 is wrong, i can't fid the appropriate syntax to save my life.
I'd like to know how to display the date a webpage (or more specifically, a file) was last modified.is there a way to read off data Windows stores for each file (there's a create date and a last modified date) and response.write-ing it to a webpage?
basically it all boils down to me being to lazy to manually update the "this webpage last modified: (date)" status
i attached the file, i want to know if it would be possible to pull data out of this file?
View Replies View RelatedI want to make a log file in which only a date and time are written, when a certain page is visited.
Most scripts and tutorials explain only about how to read a file, and how to write a file.. not on how to write a line at the end of a file(or beginning). I tried the following, but this does not work: Code:
I'm using server.mappath to list a directory's contents. The code works fine, but the owner wants to know if there's a way to display the list by the date the file was posted, instead of the alpha order that it is presented by? I haven't been able to find an answer.
Here's what I'm using:
I've gotten a subroutine to almost work as I want it to, but it's refusing to show the newest file. It seems to choke on files created near midnight, just never showing them at all, and the date compare is showing an equal number for two different dates, though it surely shouldn't.
The code is running here: http://www.devedia.com/wiki/
The object is to show most recent file first, oldest file last. I have some leftover code in here to organize files by month created, but I removed the folders for debugging. The program moves any files created the previous month into a folder on the first of the month.
The folder name passed in is an X for recent files, a folder name (like 2005_04) when the files were sorted by folders.
What I'm hoping for from the intelligent people in the forum is either an eyeball on the subroutine to help me find where it's losing the midnight/most recent files, or a better idea on sorting by created date using the file system object and asp only. (NO recordset objects.)
And here is the subroutine. (sorry about the indenting... copy and paste it to read it better?)
Code: ...
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
i'm new here and i'd like to ask if there's someone who knows how to compare date() function and date from database with date/time type inside select statement so i don't have to do if..then..else
View Replies View Relatedsql = "UPDATE Marknad SET" _
& " Typ ='" & Typ & "'" _
& ", Modell ='" & Modell & "'" _
& ", Arsmodell ='" & Arsmodell & "'" _
& ", Beskrivning ='" & Beskrivning & "'" _
& ", Stad ='" & Stad & "'" _
& ", Prisidé ='" & Priside & "'" _
& ", Fornamn ='" & Fornamn & "'" _
& ", Efternamn ='" & Efternamn & "'" _
& ", Telefon ='" & Telefon & "'" _
& ", Epost ='" & Epost & "'" _
& ", Datum ='" & Datum & "'" _
& " WHERE (((Marknad.Annonsnr)=" & Request.QueryString("id") & "))"
DatabaseConnection.Execute sql
---
Above does work as I want it to do BUT it inserts 1/8/2006 instead of 8/1/2006 as it should!
The best thing would be to exclude the date from updating at all, but when taking away the line:
& ", Datum ='" & Datum & "'" _
It gives an error... how do I solve this?
I forgot, you might want to see this:
Datum = date
In my page i have two combobox. one for year and one for week numbers.Now my prob is
1.when i select a year from combo box 1, second combox box will display the number of weeks in that year.eg if i select 2005 it display me list from 1 to 53 as there are 53 weeks in 2005.
2.when i select a weeknumber from combobox 2 and press submit button it ll display start date and end date of entered week.
I am trying to compare two dates. My problem is no matter what the value of mydate, it is still fall in the first IF statement condition (even if mydate is 10/10/2004). Any advise for this matter?
mydate = "6/6/"&year(date)
IF date() <= mydate THEN
response.write "first half of the year"
ELSE
response.write "second half of the year"
END IF
I am trying to construct an SQL statement that can grab all of the entries out of a table, where the Date field consists of today's date. The Date field is called 'DateTime' - and it is in a General Date format (DD/MM/YYYY HH:MM:SS). I obviusly want to use an SQL statement like this:
SELECT * FROM tblExample WHERE (DateTime = Date());
However, that wont work because Date() will only return a short date (DD/MM/YYYY).
I would like to modify this so that the first available date that can be selected is five BUSINESS days out. The script only shows Mon-Fri so if the date is Tue Jul 13, 2004, Tue Jul 20, 2004 needs to be displayed. Code:
View Replies View RelatedI am trying to compare a date in my database to the current date. MySQL statement is:
sqltemp5="select * from users where dateclosed <= '" & date & "'"
What I am trying to accomplish is exclude records where the dateclosed field is older than todays date. Such as if dateclosed = 6/30/2004 then today being 08/25/2004 that record should be excluded.
In a connection string, I have the following:
sql3 = "SELECT DISTINCT State FROM Property Where TypeID = '" & srch_cat & "'"
In the database, is a field called expiredDate I am trying to show only records whose expiredDates are greater than todays date, but I am messing up somewhere. The values in the fields are as this: 3/7/03 (or something like that...no time is added to it)