Re: How to extract Month,Year,YearMonth fields from Excel file name?
First you need to load all data to make good data model. That model may from fact table. From fact table, You can extract and develop only one date field after you can use Month(), Year() .... for DateField..
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)