Split, Convert Date

I have a form which is posting a user entered date to an asp page. The date is then used in a SQL string.

The format of the date is received as dd/mm/yyyy, with the user typing the '/' as well

how can I convert it to yyyy-mm-dd

----------------

I have tried this, but I think I need to strip out the '/' ??, as it is
not working

D1 = cdate(request.form("date"))

strDay = Day(D1)
strMonth = Month(D1)
strYear = Year(D1)

NewstrDate = strYear & "-" & strMonth & "-" & strDay

View Replies


ADVERTISEMENT

How To Convert UK Date To US Date Using .asp & MS Access

I have built an online booking system for a hotel and all is working fine except for the fact that the ‘From’ and ‘To’ dates are saved in the MS Access database in US format. The user selects from a date picker pop, which places the in the textfield as English format e.g. 02/12/2007.

However when I try and save this value into the date column in my DB I obviously receive an error because the formats are different. Please could someone advise me on the best way to convert an English date to a US in order to insert this into the DB using ASP & MS Access.

At the moment I am using plain text as the column type, but this is not ideal as I want to start to run queries against the 2 dates.

View Replies View Related

How To Convert Date From Mm/dd/yyyy To Dd-mon-yy

I'm using Access database. There is a date field with the medium format (dd-mon-yy).

Through ASP Form, I enter a date which is in mm/dd/yyyy, How do I convert this in to medium date.

View Replies View Related

Need To Convert Sql Date To Text

I am trying to compare a variable with a db plain text field as follows:
access db has field named HFRNUM as text .... ex: 12182003-A

I create a variable in vb as follows:
Dim hfr_today
HFR_Today = (Month(DATE)) & (DAY(DATE)) & (YEAR(DATE)) & "-A"

Unfortuantely, I think the HFR_Today var is not text and when I look for a record that is LIKE or = the var, it returns blank.

I display my variable and see 12182003-A, yet it does not find the record that matches (except data type perhaps?) Is my variable of a different data type, and if so, how can I make it plain text?

View Replies View Related

Convert The Week To Date

Can anyone please tell me is there any method to convert the week to the date?? For example If the week is 6 then we can get the date where the date is between '2/1/2004'
and '2/7/2004'

View Replies View Related

Convert A Date String

I've got an ASP script connected to a db table with a datetime field which is filled mannually for each record. When I want to select only those records with a date greater than todays date using this sql query:

Select * from fixtures where home_team_code = '" & idno & "' or away_team_code = '" & idno & "' and game_date > '" & today & "' order by game_date asc

it returns all records rather than only records with a date in the future. Is this something to do with the fact that i'm comparing a string to a datetime?? Can I use a VBScript function to make the string comparable to datetime?

View Replies View Related

How Can Convert Date Format?

I ve a problem regarding the date format. i m using access as a database and want to insert date in dd mm yyyy format but wen the date is less than 12 then it converts it into mm dd yyyy and store it like that. this is really creating a problem .

View Replies View Related

Convert Weekday To Date

I've got a shipping date field which I read from a database, I want to bring up two weeks of data based on the shipping date.

For example, If the weekday was Tuesday id like to convert the weekday to a date then bring up the results based on the next upcoming Tuesday and all the orders that are inside a future 2 weeks shipping date, as above. How can I convert a weekday to a date, is this possible?

View Replies View Related

Convert Date String

I want insert string date from web form into oracle DB, using following to get date value:

sUpdateTime = Request.Form("date")

the date format the user enetr on the web is mm/dd/yyyy: h24:mi:ss (e.g. 04/13/2005 13:35:01). UpdateTime datatype in Oracle is date, so when insert sUpdateTime into DB, using following code got problem, I knew using To_Date (...) in the insert sql, but don't know the syntax.

strSQL = "Insert into table1 (UpdateTime)"
strSQL = strSQL & " values (?)"
oCmd.CommandText = strSQL
oCmd.Parameters.Refresh
oCmd.Parameters(0) = sUpdatetime
oCmd.Execute

View Replies View Related

Dateadd And Convert Date Problem

Does any one know how I can use DATEADD and COVERT in the same select statement for retrieving data from a smalldatetime field?

I want to retrieve a date, add a year to it, then convert it to dd/mm/yyyy format without the time showing. It works seperatly EG:

convert date - SELECT adId, CONVERT(CHAR(11),datefrom,103) AS datefrom1 FROM ...
Add date - SELECT adId, DATEADD(year, 1, datefrom) AS dateto FROM....

How do you combine the 2 statements? I have been going slowly mad trying to figure this out

I’m using ASP3.JS and MS-SQL db

View Replies View Related

Convert String To Date-format

I try to convert a string in to date format, but I didn't succeed until now.

I get a specified date in this form:

date = "20060808"

In the first step I convert the date to a valid date-format:

convdate = right (z,2)&"-"& mid(z,5,2)& "-" & left(z,4)
'looks like this now: "08-08-2006"

Now I want to put this value in a date-format to adding and substracting a days much easier for me.

test = (date)convdate
test = test+15

The problem is that I don't know how to convert into date format.

View Replies View Related

Convert A String To Date Type

I need to convert a string that I pull out from a XML-feed to a valid date format. The date format in the XML-feed is like this:

2005-01-12T10:06:42.8130000

I want to change convert to a date type, in
this format:12.01.2005 12:06:42
(mm.dd.yyy tt:mm:ss)

View Replies View Related

Date Issues Asp To Access Db Convert To Mysql Db

having issues submitting dates to a mysql db, ive converted the database from access to mysql and im having issues submitting dates. this is what i have when submitting to access
Code:

View Replies View Related

Split Function To Split First Letters

I have a variable which holds college names

strcollege="University of California"

i want a variable to save UoC

what i meant was there are 3 words University of California

so i want the first letter in each word to be stored in a variable ....

View Replies View Related

Split Array But On Every Second Split?

I have a string

212334||327362737||437437||47347837||8347834||

etc

but i want to enter them into a databse

but it must be as 1356235 then field 2 is 125662

dont know if this makes sense

each number is a team in a match so team 1 plays team 2, enters into databse
then move on to the next 2, in that array.

i cant seem to get it to do 2 at a time, without ending up with an endless loop or team 2 being team 1 on the second entry.

View Replies View Related

How To Check The Date Difference Between The Current Date And The Booking Date?

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:

View Replies View Related

SSN Split

One of my fields is the customer's social security number, all originally
entered as a 9-character string. How can I split and display that into 3-2-4
format?

View Replies View Related

Split

As I can split a string that contains char " "

split(string, " ") it is not correct

View Replies View Related

Split()

What I need to do is get the content of a text file, one line at a time, and break it up using , as a delimiter.

So far I can open the file and print out all the content, but all I am getting is a million ???????'s on the screen, and not the file. Here is what I am using: Code:

View Replies View Related

Split()

How can I calculate the number of the substrings below?

Code:

Dim txt

do until rs.EOF

txt=Split(rs("diastima"), ",")

For i=1 to number_of_substrings
Response.Write txt(i)&"<br>"
next

rs.MoveNext
loop

View Replies View Related

Split First & Last Name

I have value sSearch = Lastname Firstname

I need to split it into two separate field:

sLast = Lastname
sFirst = Firstname

I tried

arrSearch = split(sSearch, " " )

but how do I actually get the values?

View Replies View Related

Split And Do

I need to send a mail for each address I found in one var. The var is as follows:

emails = "onemail@onedomain.com , other@othermail.com , another@another.com "

How Can I make a "do while var not end"?

View Replies View Related

Split Function

I want to take a server variable and split it. It would look something like this:

varServerVariable = fistname.lastname

I want it to look something like:

first = firstname
last = lastname

I know that I need to use the Split Function, but I'm not sure of the syntax.

View Replies View Related

Split Records

Plz guide me on the follwoing..
database=storedb
table=product

for e.g i m having 50 records in databse i would like to display the 10 records
on one page and other on second page and so on.. using asp.

View Replies View Related

Split() Using Database

I have a section where users can add their 'favourite venues' to a list. This is stored in a column in the users table, for example:

10,8,1,18,26

On the user area I can do a select drop-down with all their favourite venues easy.

When I try to use the same (slightly modified) code on the venue detail page to determine whether the user has the venue in their favourite to link either to ADD venue (not currently a fave) or REMOVE venue (already on the faves list) it only recognises the last added venue, i.e. (working on the list above) venue #26.

Here is the code I'm using: Code:

View Replies View Related

Split Up Values

What I'm trying to do is to split up a value into two images.
For example: Rs("num") displays "12". How do i display the 12 as "1.gif" and "2.gif"?

View Replies View Related

Double Split

how can I double split this string and pu the values into an array?

string = 2_3, 4_5, 6_8;6_9, 4_6; 3_1

I need the split after "," and ";"

View Replies View Related

How To Split A Word !!

I am looking for a function to split my string into subsequent parts. I am having a textbox from where user can enter more then one numbers (23, 456, 89, 394 etc), and now I want to write a function which return this sting into this fashion i.e.

23
456
89
394

View Replies View Related

Split For String

there is a method to split a string with a delimiter

checkDelete = Request("checkDelete")
arrayDelete = Split(checkDelete, ",")

my string is Trim(arrayDelete(i)), that has the format "number_number".
I want to put the two numbers in two different variables.

View Replies View Related

Split A Email

i am trying to split an email address into a string.Basically, what i wanna do is take the first part of the email just before the "@" symbol and insert it into the database.
How can I do this using asp?

View Replies View Related

Split A Number

I have this number

var mynum="01-12-09-908"

I want it to be saved in 4 diff variables like

mynum1=01
mynum2=12
mynum3=09
mynum4=908

Can someone tell me how I can do it ....

View Replies View Related

Split Numbers!

The number '60' can be written as (50+10) or (25+35) or (15+45) or (7+53) etc... but I want the output as (50+10) only when 60 is typed in a textbox & the Form is submitted. How do I do this?

View Replies View Related

Split By Linebreak

I am trying to split a return value from a post by the linebreak at the end of each line in the return value ....

View Replies View Related







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