[suhabassam]

Hi,
I am trying to save some fields in a table, one field with type Date. It only accepts date with the following format (01-Jan-05). I am reading the date as a string (24/09/2005) and then convert it to date.
But i do not know to convert it to the following format (24-Sep-05) to store it in the table?? Please I need help urgently. This is my code :
<%
String issuedate = request.getParameter("issuedate");
DateFormat format = new SimpleDateFormat("dd/MM/yyyy");
myIssueDate = format.parse(issuedate);
mindecree.setIssueDate(new java.sql.Date(myIssueDate.getTime()));
%>

Note:I've tried using the following:
SimpleDateFormat format = new SimpleDateFormat("dd-MMM-yy"); Date myIssueDate = format.parse(issuedate);
But i got (Unparseable date:"19/5/2005" ) error .
Any Idea pls.???

just use the date format do not specify options other than small, medium, or long (if i remember right) then you can use now() to set the date time based upon the server.

when you want to display it you can use formatdatetime(strin,format)

[toth]

You can also try this where you need to display the date

Code:

[<%= DoDateTime((YourRecordsetHere.Fields.Item("issuedate").Value), 1, 2057)%>]

you can change 2057 to your local settings, if it isn't correct

Put this code on top of your page

Code:

<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>					
function DoDateTime(str, nNamedFormat, nLCID)				
	dim strRet								
	dim nOldLCID								
										
	strRet = str								
	If (nLCID > -1) Then							
		oldLCID = Session.LCID						
	End If									
										
	On Error Resume Next							
										
	If (nLCID > -1) Then							
		Session.LCID = nLCID						
	End If									
										
	If ((nLCID < 0) Or (Session.LCID = nLCID)) Then				
		strRet = FormatDateTime(str, nNamedFormat)			
	End If									
										
	If (nLCID > -1) Then							
		Session.LCID = oldLCID						
	End If									
										
	DoDateTime = strRet							
End Function									
</SCRIPT>

It will display 29/10/2005 as 29 October 2005
So store it as dd/mm/yyyy

If the table got the value Now() it will auto generate the date
Leave it blank if you want to add a custom date.