By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,773 Members | 2,307 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,773 IT Pros & Developers. It's quick & easy.

Undefined function Format

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.