Update/string question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to update values in the date field from this: 4/12/2006 to this:
4/12/06
How do I strip out the "20" ?

Thanks,
Todd
 
Dear Todd:

Does this column contain a date/time datatype, or something else?

If it is a date/time value, then your problem is not what is in the column.
What is in the column is a number which cannot be changed without changing
the date which it represents.

Instead, it may be that what you want is to format this date/time value in
different ways. The Format() function gives you many options to do this.
It can give the appearance you want to see, and many other formats. It can
give you 3 character month abbreviations, such as "12 Apr 06" or "12 Apr
2006". It can give you full month names, like "12 April 2006" or "April 12,
2006".

It does not sound like you really want to change a date/time value, but you
may want to change how it is displayed. This is formatting.

Have I made it clear that formatting and value are two completely separate
issues?

Tom Ellison
 
Tom,
Yes it would be a formatting issue. The column is set for date/time
however I saw that the Short date option had a four digit year. How could I
change it to a two digit year at the table level?
or

How could I work a function into the report/query that uses this table to
give me a two digit year?

Todd
 
Dear Todd:

Please see the custom date formatting capabilities of the Format() function
in help.

Tom Ellison
 
How could I work a function into the report/query that uses this table to
give me a two digit year?
Click to expand...

No function is needed. Simply set the Format property of the report or
form textbox to mm/dd/yy.

John W. Vinson[MVP]
 
Back
Top