Shorter format for Date field from Access

[Jörgen Lundberg]

Hi,
I'm using Frontpage 2002, Access 2002 and IIS 5.1 on my workstation. In the
database I have a Date/Time field that I will present in a shorter format in
Frontpage. I can't find another way to do it except with a SQL-statement. It
works fine in Access and when i verify it in Frontpage Database Results
properties but in the browser I get an error:

Database Results Error
Description: [Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1.
Number: -2147217904 (0x80040E10)
Source: Microsoft OLE DB Provider for ODBC Drivers

My code looks like this:
SELECT Ad_head.Date_Time, Ad_head.Picture, Ad_head.headline, Ad_head.Price,
Ad_head.Category, Ad_head.hid, Format([Ad_head].[Date_Time] ,'d\ mmm\ hh:nn')
FROM Ad_head
WHERE (((Ad_head.Sellorbuy)="Sell"))
ORDER BY Ad_head.Date_Time DESC;

I have also tested without Order By, with the same result.

Has anyone a clue??
Thanks very much
Jörgen

 

[Kathleen Anderson [MVP - FrontPage]]

You need to use commas, not slashes, in your FORMAT function - see:
http://www.spiderwebwoman.com/tutorials/working_with_dates.htm