Date Formatting

[Darryl W]

Hi all,

Seems to be a simple problem...

I want to have a text field in a table that contains a date formatted a certain way. For example, if I enter 01/01/2007 in FieldA (data type:date), I wish to auto enter in FieldB (data type:text) "January 1, 2007".

Is there something I'm missing or do I have to break down the date via a calculation into the month name and so on...

Thanks for your input.

Darryl

[comment]

You can format a DATE field that way. If you insist on the result being text (why?), you will have to break it down as you said.

[Darryl W]

I wish to create a permanent log field - with the date formatted a certain way.

Thanks for your input. I appreciate it.

Darryl