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

     

    Read more about Access Development Projects

    A leading European Private Equity Practice came to Xlteq to design and build a bespoke CRM tool to manage and track their investment managers, their clients, and investment opportunities. 

    Find out more

    Bristol based specialist waste paper brokerage and waste management consultancy came to Xlteq to review and enhance an existing order tacking tool built in Microsoft Access.

    Find out more

    Kent based bespoke background screening company asked Xlteq to automate the collection and upload of data necessary for regulatory background checks via an external agency online portal.

    Find out more