It's likely that your report is designed to output to a CSV or ASCII Text file for upload to your bank.

Please open the report design in Report Designer, single-click to select the date field that you wish to change, and from the menu bar select Tools > Design Formula.  

The formula window will display.  Please take a screen shot of the pop-up window that opens displaying the formula and post it in your reply to this message. I will try to help you decipher it and the changes that you need to make.

Art Minds
Senior Independent Consultant
Pasadena, CA

The formula is a JOIN formula which creates a TEXT output. As you can see from the formula, there are three other formulas that retrieve the month, day and year.  You would need to open the YEARS formula using the menu Tools > Formulas to understand how it was returning only the two digit year. You can post a screen capture of that formula if you would like further guidance.  

Replacing the TEXT field of the date with a DATE formatted field may or may not work when the output is generated to deliver to your bank, depending on whether typical date formatting characters are included, i.e.  / or - between the month, day and year fields.  Often banks required only a string of digits without formatting characters, but if your bank accepts that then you're OK with the modification you made.

Art Minds
Senior Independent Consultant
Pasadena, CA

The formula is a JOIN formula which creates a TEXT output. As you can see from the formula, there are three other formulas that retrieve the month, day and year.  You would need to open the YEARS formula using the menu Tools > Formulas to understand how it was returning only the two digit year. You can post a screen capture of that formula if you would like further guidance.  

Replacing the TEXT field of the date with a DATE formatted field may or may not work when the output is generated to deliver to your bank, depending on whether typical date formatting characters are included, i.e.  / or - between the month, day and year fields.  Often banks required only a string of digits without formatting characters, but if your bank accepts that then you're OK with the modification you made.

Art Minds
Senior Independent Consultant
Pasadena, CA