Date format output from Access to ASP

Forum|Forum|15 years ago
March 27, 2010
2 replies
2306 views

I see many have had this problem in the past with no real solution that I've found, but I'll try anyway in case I missed something.

Using MS Access, DW CS3, ASP VBScript.

My Access database date field type is Date/Time with an input mask of 00/00/00;0;_ for a format of 03/27/10 which works fine in the db. However, the output to my ASP page shows 03/27/2010 when previewed in a browser. I want the output to match the database - 03/27/10.

My regional settings are correctly set at 03/27/10. The Bindings window in DW offers many date formats which will not bind -- the binding remains "Selected...None" no matter which format is picked. If I change my db date field to text, the dates do not sort in proper order. Any solutions?

Server side applications

This topic has been closed for replies.

A

Anonymous

Thank you so much for all your help - you've been a tremendous help to me!

B

bregent

Participating Frequently

You're most welcome.

B

bregent

Participating Frequently

>My Access database date field type

>is Date/Time with an input mask of 00/00/00;0;

The input mask setting is irrelevent. Date/Time fields are internally stored the same regardless of input mask. AFAIK, ASP/VBscript does not support date output with a 2-digit year. You will need to write a custom funtion.

A

Anonymous

I had a feeling that would be the answer.... okay, more research! Thanks

B

bregent

Participating Frequently

Just use a simple function to convert it:

<%

Function FormatDate(DateToFormat)
FormatDate = (Left (FormatDateTime (DateToFormat,2), InStrRev(FormatDateTime(DateToFormat,2), "/")) _
& Right (FormatDateTime (DateToFormat,2), 2) )
End Function

response.Write FormatDate (Now())

%>

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded