• 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:

     

    Access Database Date Format Issues

     

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