format data results field

[Stephen Green]

I have a database results page that includes date and time drawn from an
Access database. Can I adjust the formatting from within FP 2002? Or do I
have to change the formatting of the field permanently in Access (2003)?

For instance, right now the date reads 10/1/2004. I'd like to see Friday,
October 1. (leaving out the year)

Thanks,

Stephen

 

[Thomas A. Rowe]

You would have to adjust this on display with ASP/VBScript, if you want to continue to use a
date/time field in Access.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

 

[Stephen Green]

Thanks, Thomas!

I found a way to do what I want within the query:

SELECT Format(start_dt, "ddd, mmm d") as fmtstart_dt

That returns "Fri, Oct 1".

The only part that is still puzzling me is how to add a period after the
three character day and month...

Stephen