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!
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!