Sam A

<div>
<div class="content wysiwyg-content">
I have a column that has values like this &quot;29MAY2018&quot; i.;e of &quot;ddMMMyyyy&quot; format. How can I convert this to date type and find difference of two dates? Please kindly give me code to do this in Access Query
</div>
</div>


I have a column that has values like this "29MAY2018" i.;e of "ddMMMyyyy" format. How can I convert this to date type and find difference of two dates? Please kindly give me code to do this in Access Query

How to convert string of format “29MAY2018” to date in access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.