Date Formula in a Query

  • Thread starter Thread starter Victor
  • Start date Start date
V

Victor

In Excel, I can convert a field which contains a date with
a mm/dd/yyyy format into a mmm-yy format.
Example: Cell A1 Cell B2
Value in B2: 04/20/2004
Formula in A1: =text(B2,"MMM-YY")
Result in A1: Apr-04

How do I achive this same result in an access query? I
have a date field called "Sale Date" that contains dates
with a mm/dd/yyyy format. I would like to:
1) Take the values in the "Sale Date" field
2) Convert it into a MMM-YY format
3) Place that result in the "Sale Month" field.

Desired Result: Sale Month Sale Date
Apr-04 04/20/04

Thanks for the help!
 
Back
Top