Newbie's question abut date function

[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 Snell \(MVP\)]

Date function is -- Date().

 

[Jorge 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

 

[Douglas J. Steele]

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.

 

[Jorge Cervantes]

That worked!!!

Thanks. 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.