Change Year format on imported database

Topic

New Reply

I have Access 2007 that I suck in a report that has the date 07/08/15, how can you change that to 07/08/1915. I need that 4 digit year format.

Reply | Quote

Replies

Are you actually importing a report, or is it something in RTF or comma delimited format? As long as you are able to get it to Access in a text field, then you can use the concatenation capabilities in Access (the Left() and Right() to put the 19 in front of the year.

Reply | Quote