Undefined function Format

[Simon]

Dear reader,

According the manuals it has to be possible to work with "Format" in
queries.

But in case I use the following expression in a query:

Format([RefDate];"yyyy-mm-dd")
Or
Format$([RefDate];"yyyy-mm-dd")

I receive the message:

"Undefined function 'Format' in expression."

My question is how to use the function Format to strip the time part from a
date field.

Tanks for any help.

Simon

[Squirrel]

I tried this; it works OK:

TheDate: Format([MyDate],"mm-dd-yyyy")

In a query, renaming a field called MyDate to TheDate while formatting it.
I note you used a semicolon, perhaps that is a problem?

HTH -Linda

"Simon" <S.******@HCCnet.nl> wrote in message
news:41*********************@reader1.nntp.hccnet.n l...

Dear reader,

According the manuals it has to be possible to work with "Format" in
queries.

But in case I use the following expression in a query:

Format([RefDate];"yyyy-mm-dd")
Or
Format$([RefDate];"yyyy-mm-dd")

I receive the message:

"Undefined function 'Format' in expression."

My question is how to use the function Format to strip the time part from a date field.

Tanks for any help.

Simon