date format.

[Bob Barrows [MVP]]

Paul wrote:

> I have a form in my web page that everyone enters in a date and
> clicks submit. On the click of submit button the date is sent to the
> sql server and runs a stored procedure. My problem is that everyone
> enters the date in a dd/mm/yy format. The sql server needs the date
> to be entered in a yyyy/mm/dd for the stored procedure to run.
>

[url]http://www.aspfaq.com/show.asp?id=2313[/url] vbscript
[url]http://www.aspfaq.com/show.asp?id=2040[/url] help with dates
[url]http://www.aspfaq.com/show.asp?id=2260[/url] dd/mm/yyy confusion

HTH.
Bob Barrows.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Raymond D'Anjou \(raydan\)]

Two suggestions:
Use a calendar and have the user click on a date (valide date garanteed)
Use three separate fields for Year/Month/Date (you will still have to
validate the date)

"Paul" <anonymous@discussions.microsoft.com> wrote in message
news:6CE196D2-EEF6-4DEA-8608-04DE64115DEF@microsoft.com...

> I have a form in my web page that everyone enters in a date and clicks

submit. On the click of submit button the date is sent to the sql server
and runs a stored procedure. My problem is that everyone enters the date in
a dd/mm/yy format. The sql server needs the date to be entered in a
yyyy/mm/dd for the stored procedure to run.

>
> Is there any code which I can run in order to change the date format

around (FROM dd/mm/yy -- TO -- yyyy/mm/dd) on the onclick event of the
submit button on my form.

> The html code for my form is as follows
> <form action="" method="post" name="accounting" id="accounting"><input

name="date" type="text" id="date"><input type="submit" name="Submit"
value="Submit"></form>

>
> I would really appreciate any help anyone can give to me as I am very new

to any type of coding and find it difficult doing some of the simple things.

> Thanks
> Not even sure if asp is needed to do this. All I know is the page is as

asp.

[Paul]

Unfortunately there where nothing in these links that helped me accomplish what I was looking for. Its a quite specific problem and unfortunately i've very little programming knowledge so im finding this difficult.
Can anyone help me please

[Aaron Bertrand [MVP]]

>> My problem is that everyone enters the date in a dd/mm/yy format.

No, your problem is that you are letting people enter a date in whatever
format they feel like. Use dropdowns or a calendar popup so you can have
more control over the input.

Also, SQL Server does not need the date to be entered in yyyy/mm/dd unless
you are casting it as a string and explicitly parsing it for that format.
What you *should* be passing is the only truly safe format to pass to SQL
Server: YYYYMMDD.

--
Aaron Bertrand
SQL Server MVP
[url]http://www.aspfaq.com/[/url]