Newbie's question abut date function

  • Thread starter Thread starter Jorge Cervantes
  • Start date Start date
J

Jorge Cervantes

I would like to add/type a date function (e.g., November 25th, 2007) to a
design view of 2003 Access. Please advise what it is. Cervantes
 
Ken,

You are correct but that is not what I want.

=Date() shows 11/25/07.

What I want is date function to express November 15th, 2007.

Jorge
 
What exactly do you mean by adding it "to a design view"?

If what you want is for the date to appear on the form when it's open, use:

=Format(Date(), "mmmm dd, yyyy")

If you really want the th in there, you'll need to write your own function
to add it: Access doesn't have that capability.
 
That worked!!!

Thanks. Jorge



Douglas J. Steele said:
What exactly do you mean by adding it "to a design view"?

If what you want is for the date to appear on the form when it's open,
use:

=Format(Date(), "mmmm dd, yyyy")

If you really want the th in there, you'll need to write your own function
to add it: Access doesn't have that capability.
 
Back
Top