I think I have a very simple issue. I am using 3 files: 1. fiscal calendar file with date, fiscal Week, fiscal year, fiscal month, 2. Historical file containing company, Inventory, Date, fiscal week, fiscal month, fiscal year and inventory data, 3. Current file containing company, Inventory, and Date (being derived from the current filename). I intend to use that date as a look up in the fiscal calendar file to get the fiscal week, fiscal year and fiscal month; build a record matching the historical file layout, append the record and save the file.
Seems simple to me. I can load the calendar, historical, current file and get the date from the filename but creating the record and storing it just isn't working. I think I understand concatenate but I get 'not found' errors when I try and use the derived date from the filename. I am deriving the date in the load of the current file. I tried naming everything the same so concatenate would just grab the data but clearly I do not fully understand it.
