In the fields that have additional text in them, is the Date ****tion always
at the right end of the string, like the two examples in your post?
--
_________
Sean Bailey
"JWeaver" wrote:
> 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
|
