Date

[ashtonp2]

I have a column of date with a date an order was created. I want to creat a new column which just shows the month and year that the order was created. Does anyone know how I can do this.

For example order created 23/05/04 would like to see in new field as 05/2004 or 01/05/2004

I am sure this is really easy but not sure how to do it

Paul

 

[SuicidED]

Hi

Put at text box on your form with the control source as order created, if thats what the full date box is called, and format this box to mm/yyyy.

Eddie

 

[ashtonp2]

Thanks Eddie for the tip, the only problem is I receive the data from another source in this way and will not be able to get the input option changed.
Any other tips ;-)

 

[SuicidED]

Hi
Add a new column to your table and run this update query
UPDATE [ANNUAL REVIEW] SET [ANNUAL REVIEW].[new date] = Format([hire date],"mm/yyyy");

ANNUAL REVIEW being your table name
hire date being your order created field

Eddie