- Local time
- Today, 00:36
- Joined
- Feb 19, 2002
- Messages
- 46,472
There is absolutely no reason for you to import and store data that doesn't work. It is very easy to fix up this data as you import it and that solves ALL problems. You never have to worry about it again. If you don't fix the data at the source, you have to fix it EVERY SINGLE TIME you use it. Your choice.
Either make the field a date with the day part always being 1 or make a text field with yymm or yyyymm and make sure the month is zero filled so that it is always two digits.
Either make the field a date with the day part always being 1 or make a text field with yymm or yyyymm and make sure the month is zero filled so that it is always two digits.