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]

Re: Undefined function Format

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.v.Beek@HCCne t.nl> wrote in message
news:4121afc8$0 $149$3a628fcd@r eader1.nntp.hcc net.nl...[color=blue]
> 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[/color]
a[color=blue]
> date field.
>
> Tanks for any help.
>
> Simon
>
>[/color]