csv File date issue importing

[The Missing Man]

Hi All,

Here is the problem. I am importing a csv file with a particular date within it. Before importing the file I break down the date into separate month, day, year fields. Everything seems to import correctly but when I take the Month imported field and use it to create a Month name field instead of the 12 appearing as December it shows as January. Any ideas why and how to fix this? I have included the csv file and my filemaker file.

Thanks in a advance

DateIssue.zip

[comment]

The CSV date is in m/d/y format, and that is also the format of your file. Unless your OS is set to use a different format, why not import the date directly?

[The Missing Man]

I don't want to import the date directly because for some strange reason, throughout the year sometimes the date gets screwed up mixing everything up, then it goes back to normal and then goes screwy again (there seems to be no method to the madness) so to try and avoid this I thought to separate the month, day and year before importing. FYI: My OS is set up to read M/D/Y .

Having said that if M/D/Y matches on all accounts I still don't understand why 12 is reading as January?

There has to be something wrong, and with minimal fields I cannot figure out why. There is no complex calculations so it should work, should it not?

[comment]

I still don't understand why 12 is reading as January?

It's because the MonthName() function takes a date as its argument, not a month. If you change your calculation to =

MonthName ( A_ExcelMonthConversion )

it will work as expected.

[The Missing Man]

Thank you