This is my situation.
Using a query I have extracted the three parts of the date field from a table into its' numeric form.
The date was orignaly in the SHORT DATE FORMAT : dd/mmm/yy (28/Feb/01)
And was extracted using the following DatePart Expressions:
To Produce VALUES : 28 02 2001
In query Fields Expr1, Expr2, Expr3
I need to recombine the date to insert into a report and while the day and year are ok as nubmers. I need to convert the Month back into its 3 letter form.
How can I do this.
If anyone can help me, that would be great.