ASP Format Date and Time Script

It's great to be here to find every code u require. i wish u people all best
for the future.

It's my one source for solution : codetoad

This is Great effort For creating This Code and this code enhance the ASP Techninques.
So Again this is great effort.

thanks

Let me start with complimenting you with this great site!

I have a site where people can enter data and change them later.
One of the things that they enter is a (release)date. The format is dd-mm-yyyy (Dutch). However, somehow the server (I think it's the server...) turns it into mm-dd-yyyy. This happens only when the original day is less than 13. When i enter 13-5-2004, nothing happens. when i enter 12-5-2004 the result is 5-12-2004.

What is the solution?

thanks
Jos

I too have the issue using MS Frontpage 2000 where a user enters a date of dd/mm/yyyy and this gets posted to my MS Access database as mm/dd/yyyy, I see in your article that you mention the code '<%session.lcid=2057%>' where and how can this be used to resolve my issue? Many thanks....a tired and worn out user....

Very good coding.......

Candle in the darkness of load-sheding...... huuh hhuuh hhaaaaah !

Very nice and simple also. Great Job. I Found very fruitful as soon as I found it......

I have tried the <%session.lcid=2057%> but it didn't work. Please anyone tells me how to apply it?

please those who have successfully used the code for
formating date as DD/MM/YYYY plz tell us how and where to
apply that <%sesssion.lcid=2057%> will be used.

thanks

Hi all,
Please forgive my ignorance, but I am new to the .NET world and am trying to format the output of my data grid. Currently it is showing date and time and I only want to see the date. How can I do this?

Thanks,
Ron

how to find the date format in dd-mmm-yyyy format ?

<%sesssion.lcid=2057%> and conver functions

It did worked for few days and then it was showing me some error informing "Arithmatic conversion error......."
Still trying to figure out the issue.

I was using nvarchar to store date value in to datbase and than was using convert function as below
convert(datetime, columnname, 131) to convert to uk format.

of someone knows the resulution, plz advise me.

First of all, thanks for posting a very helpful article Ü

Secondly, can you pls help me with this one..

We are currently supporting an old application using Win NT 4.0, Oracle 8i, MTS/IIS, and ASP.
During run-time, most of our pages has a textbox where it displays the current system date (default format is mm/dd/yyyy) on form load. Lately, there are times that it displays an invalid date format such as 04/11/197 or 04/11/07. As an immediate solution , we just restart the production server. This is an intermittent error and we cannot replicate it in our test server.

Do you have any idea why it happens?

thanks in advance Ü

Hello
first of all thank you for comments, here are many question regarding date formating, but have no answers on this site, so i have decided to put the answers of similar questions on this site.
Question By dubzap
Answer
first of all put this statement <%session.lcid=2057%> top of your page then create a database field with settings "date/time" then try to dates and print on you page and see the result.

a similar example of this code i have put on a site where from you can check by adding removing and editing dates , the link is as
http://www.australiantalentdirectory.com/mydate
if you have any problem , you are welcome to ask at the address of webmaster@australiantalentdirectory.com
Regards

I maintain a site that features Classical Music composers, many of which lived hundreds of years ago (Mozart, Beethoven, Haydn, etc.)

Has anyone encountered trouble formatting dates prior to 1750?

When I have dates from 1750 or before, the year displays properly but often the month or days are innacurate from what is in my database.

Any suggestions?

Español:

Para los que tienen el problema del formato de la fecha.

Intenten esto:

<%
Datemmddyyyy=Now()
Dateddmmyyyy=month(Datemmddyyyy)&"/"&day(Datemmddyyyy)&"/"&year(Datemmddyyyy)&" "&FormatDateTime(Datemmddyyyy,3)
%>

Cambiara el formato de esto MM/DD/YYYY a esto DD/MM/YYYY.

Suena raro pero funciona =).


English:

To anyone that has the format date trouble.

Try this:

<%
Datemmddyyyy=Now()
Dateddmmyyyy=month(Datemmddyyyy)&"/"&day(Datemmddyyyy)&"/"&year(Datemmddyyyy)&" "&FormatDateTime(Datemmddyyyy,3)
%>

Will change the format from this MM/DD/YYYY to this DD/MM/YYYY.

sounds weird but it works =).