Web Development·12,157 discussions

What’s the correct way to store a date??

Locked

I’m using a

to ask the user for a date. Like so…

” METHOD=”GET”>
Date:

Then i’m storing the date…
strIBUSKEY = “‘” & Trim(Request.QueryString(“ibuskey”)) & “‘, ”

When i attempt to write the above string into a record’s date-field i get an error that i’m trying to write a string of text into a date-field.
Now, i’m new to VBScript (which is what i’m using to write my ASP’s). So, obviously, i’m storing the date in an inappropriate variable type.

How should i be storing this date info?
—
[email protected]

Topic

What’s the correct way to store a date??

In reply to What’s the correct way to store a date??

You have to read date in asp as –
strIBUSKEY = Request.QueryString(“ibuskey”)
But u must make sure that date value is entered in html form in correct format. Input format of date will depend on the database ur using. e.g in Oracle, u must enter date by default as DD-MON-YYYY. If u choose some other input format, u have to convert the date input in asp appropriately e.g using to_date function in Oracle. You must give instruction in HTML page for the format u want in input.
Details for other databases are different. Check with them individually.

regards
-mukul

What’s the correct way to store a date??

In reply to What’s the correct way to store a date??

What’s the correct way to store a date??

In reply to What’s the correct way to store a date??

hey
You should tell the users the format you want or gather the date string from seprate input boxes such a select combo box for the month, and 2 input boxes for the year and date.
Once you have the datestring you can convert it to be of datetime format using the Vbscript function call as follows
datestring = cdate(datestring)
in you SQL statement ensure that the you enclose the datestring with two pound signs(#) as in sample below
SQLSTRING = “INSERT INTO Timesheet (Date)values (“& datestring & “#)”
if you goto http://www.itknowledge.com you will find some good books on ASP and VB script.

Hope I helped

What’s the correct way to store a date??

In reply to What’s the correct way to store a date??

[Author]

Replies