I need some help. I created an append query in which data from the web is downloaded and is appended into an existing table. Easy enough. Here is my delima.
My PO Number is set up to use our fleet number of the van and the date of order. Example 18081512 would reflect van 15 and the order was placed on 08/22/12. The append query asks for the PO number and I can separate out the Van number into its own column just fine using the Right function.
PROBLEM: I use Format(Right([PO FIELD],6),"mm/dd/yy"). It returns 03/03/23 in for the service date field. This is what I want the query to return to me.
PO# Van Date
18081512 18 8/15/2012
Any help with be appreciated!
My PO Number is set up to use our fleet number of the van and the date of order. Example 18081512 would reflect van 15 and the order was placed on 08/22/12. The append query asks for the PO number and I can separate out the Van number into its own column just fine using the Right function.
PROBLEM: I use Format(Right([PO FIELD],6),"mm/dd/yy"). It returns 03/03/23 in for the service date field. This is what I want the query to return to me.
PO# Van Date
18081512 18 8/15/2012
Any help with be appreciated!
