Incorrect Dates in table (flat file) output

Q: Our price schedule effective dates are coming out with “00” for the month in our tables.

A: You may have an incorrect format string set on the date column for the table. The format you want is:

yyyyMMdd

You probably have: yyyymmdd

Notice the case. In a date/time format string, “MM” is a placeholder month and “mm” is a placeholder for minutes.