Access Database Solution for Date Format Problem

Access Database Date Format Issues

If you have tried to store a date from Access into a SQL database, you may have run across a problem where the day and month are reversed. So the 3rd July (03/07/2018) gets stores as 7th March (07/03/2018). In order to prevent this, you need to convert the date into a format SQL recognises and the easiest way to do this is with some code:


Simply send a date to the function and it will return the date as a string you can use in a piece of SQL.

For a free consultation

Either call us now on 020 3817 6945 or fill out the form below and one of our team will be in touch.

The contact form requires that you configure reCAPTCHA in the site configuration.

The contact form requires that you select an email template.