Date format for ASP page

[tamnet]

HI,
I have a asp page with a form that submits data to an access DB in the form i have a date field which is foramtted as dd/mm/yy using the following 2 functions

<%
Function Pad(strText, nLen, strChar, bFront)
    Dim nStartLen
    
    If strChar = "" Then 
        strChar = "0"
    End If
    nStartLen = Len(strText)
    If Len(strText) >= nLen Then
        Pad = strText
    Else
        If bFront Then
            Pad = String(nLen - Len(strText), strChar) & strText
        Else
            Pad = strText & String(nLen - Len(strText), strChar)
        End If
    End If
End Function
%>

<% '***Start Function strUKDate
Dim strUKDate, MYdd, MYmm, MYyy
MYdd = DatePart("d", date())
MYmm = DatePart("m", date())
MYyy = DatePart("yyyy", date())
strUKDate = (Pad(MYdd,2,"0", True) &"/"& Pad(MYmm,2,"0", True)  &"/"&right(MYyy,2))
'***End Function strUKDate
%>

[COLOR=red]Then this is my textfield code[/color]

<input name="txtSdate" type="text" id="txtSdate" value="<%=strUKdate%>" size="10" maxlength="10" readonly="true">

When the date is stored in the DB it is shown as dd/mm/yyyy

I then display the date in another ASP page from a recordset but i would really like it shown as dd/mm/yy

I have tried using the following

<%=FormatDateTime((RSAlldetails.Fields.Item("Start_Date").Value),vbShortDate)%>

but this still displays as dd/mm/yyyy, is there any way i can get my desired format or am i stuck with what i have ?

any help appreciated

Thanks
Paul

 

[ChrisHirst]

thread333-912956

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.