NEED DATE TO FORMAT MMDDYY

[Lambro]

I have a value for my date field.

Examples:
7/23/2004
10/11/2004
11/9/2004

When I save these values to the database I would like them to be converted to the following before being inserted:

Was: Now:
7/23/2004 072304
10/11/2004 101104
11/9/2004 110994


Is this possible? And how? Thanks

 

[Tarwn]

You could simply concatenate the values together from Day(date), Month(date), Year(date)...odd, actually it looks like your doing mmddyy...same difference. The only necessary adition at that point would be a ZeroFill function, perhaps something like:

Function DateToString(myDate)
   Dim dd, mm, yy
   dd = ZeroFill(Day(myDate),2)
   mm = ZeroFill(Month(myDate),2)
   yy = ZeroFill(Right(Year(myDate),2),2)

   DateToString = mm & dd & yy
End Function

Function ZeroFill(numStr, numChars)
   If len(numStr) >= numChars Then
      ZeroFill = numStr
   Else
      ZeroFill = String(numChars - len(numStr),"0") & numStr
   End If
End Function

Might be a better way to do it, but that should get you from a to b,

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[Lambro]

What's the best way to call this function?

I have my textbox called PaymentDate and the value is 7/25/2004. is there a way to call the function with the onBlur and store the new value in a hidden textbox?

 

[Tarwn]

Nope, ASP code is all server-side, texxtboxes and events are client-side. You could write a <script> block to do this with either client-side javascript or client-side VBScript, but with ASP you would put the function in the page that one is submitting to and execute the function on the value that was POST'd back from the client.
In this case you would want to execute it like so (on the next page):
newDate = DateToString(Request.Form("PaymentDate"))

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/

 

[amarsafy]

How can we do it in a DOS script to get the output in 'DD/MMM/YYYY'

 

[Tarwn]

I don't know about a DOS script, do you mean in a vbs script?

That function above should work exactly the same in a vbs script, you would just have to call it with the date you wanted to convert.

-T

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
The never-completed website:

http://www.tiernok.com/