I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields.
Is there a way of converting these fields to concatenate the date to be able to link easily to other files? Not sure why they chose to do it this way, maybe someone has experience of this.
August 2, 2011 9:20 PM
March 31, 2012 7:20 PM