Thanks for the reply.
I copied my database and am making these changes in the "Dummy" version
before applying them to the database that we are using to ensure that
information doesn't get lost. I had forgotten to mention that originally
the
fields were set as Text fields and were converted to Date/Time fields. I
figured out how to do what I wanted after I posted my question. I set the
Format property in the Table and the Form as "mm/dd/yy ddd" and it works
fine.
Since the fields were originally set as Text fields, sometimes information
was entered in Start Date field as "either 12/3/08" and End Date field as
"or
12/4/08". When I converted these 2 fields to Date/Time fields I lost
everything in them, even the date ****tion. I decided to add a Date Note
field to capture this type of information when it is not specific to a
particular date. Is there a way that I can copy information that isn't
strictly a date to this field first so that when I convert my working
database, I don't lose this information?
--
JWeaver
"Beetle" wrote:
> In the Format property of your form control put;
>
> mm\/dd\/yyyy", "ddd
> --
> _________
>
> Sean Bailey
>
>
> "JWeaver" wrote:
>
> > I have a Form where a date is entered for service to begin. I need to
have
> > the day of the week displayed also. For example, if I entered
"12/02/08", I
> > want it to display as "12/02/08, Tue". Right now, this information is
> > entered manually by the user but different users are entering this
data in
> > different ways and I want to make it consistent so that it will sort
properly
> > in queries and on re****ts.
> >
> > I have tried adding =Format(Date(), "dddd, mmm d yyyy") to the Format
of the
> > field on the Form but this doesn't work.
> >
> > What is the best way to do this?
> > --
> > JWeaver
|
