Format Date On Page Load

Dev Shed Forums Sponsor:

July 16th, 2004, 02:03 PM

bryanpl

Registered User

Join Date: Jul 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

Format Date On Page Load

All:

I am filling a html form with some data from SQL server. I would rather not format the date from within the stored procedure but have the date formated as it's loaded into the web page. Is this possible using javascript and if so how.

Thanks in advance

July 16th, 2004, 02:06 PM

jacktasia

Contributing User

Dev Shed Intermediate (1500 - 1999 posts)

Join Date: Feb 2004

Location: Lawrence, Kansas [KU]

Posts: 1,559

Time spent in forums: 2 Days 14 h 10 m 18 sec
Reputation Power: 14

there are few questions that could more easily be answered by searching google.

but, welcome to the fourms!

and please read how to post a question if you already have not:
http://forums.devshed.com/t157126/s.html

__________________
Jack
---------

Mancala Time: Play mancala online for free. A multiplayer game.

Find Words: Finds words for crossword puzzles and word games.

July 16th, 2004, 02:27 PM

bryanpl

Registered User

Join Date: Jul 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

Thanks, I tried searching google but could not come up with an answer.

I don't need the format for data input, I need the date formatted as it's loaded into the control from the stored procedure.

July 16th, 2004, 02:29 PM

jacktasia

Contributing User

Join Date: Feb 2004

Location: Lawrence, Kansas [KU]

Posts: 1,559

Time spent in forums: 2 Days 14 h 10 m 18 sec
Reputation Power: 14

Quote:

Originally Posted by bryanpl

Thanks, I tried searching google but could not come up with an answer.

I don't need the format for data input, I need the date formatted as it's loaded into the control from the stored procedure.

okay, so how it's it stored and how do you want it displayed?

July 16th, 2004, 02:37 PM

bryanpl

Registered User

Join Date: Jul 2004

Posts: 3

Time spent in forums: < 1 sec
Reputation Power: 0

Stored in database as dd/mm/yy. i would like it to be displayed as dd-mmm - yy

e.g. 01/12/04 01-Dec-04

Thanks in advance

-=Bryan=-

July 16th, 2004, 02:46 PM

jacktasia

Contributing User

Join Date: Feb 2004

Location: Lawrence, Kansas [KU]

Posts: 1,559

Time spent in forums: 2 Days 14 h 10 m 18 sec
Reputation Power: 14

Code:

<script language="javascript">
<!--
function formatDate(fs) {
	var theMonths= new Array();
	theMonths[0]="Jan";
	theMonths[1]="Feb";
	theMonths[2]="Mar";
	theMonths[3]="Apr";
	theMonths[4]="May";
	theMonths[5]="Jun";
	theMonths[6]="Jul";
	theMonths[7]="Aug";
	theMonths[8]="Sep";
	theMonths[9]="Oct";
	theMonths[10]="Nov";
	theMonths[11]="Dec";
	
	var fs = fs.split('/');
	return fs[0] + "-"  + theMonths[Number(fs[1]-1)] + "-" + fs[2];
}
//-->
</script>

Format Date On Page Load

Developer Shed Advertisers and Affiliates