Convert Date In Access<\/strong> – Serial Number, Text Date, First of Month, End of Month\/last day of month.\u00a0 MS Access will not automatically convert dates into different types, so this post will assist you with doing so quickly. To begin, you will create a new field in your query, and then continue with the conversion below that applies in your scenario.\u00a0 <\/p>\n\n\n\n <\/p>\n\n\n\n Helpful hint: Substitute [yourdate] with the name of the field that you are converting.<\/p>\n\n\n\n To convert a date in the date\/time format to the serial number<\/strong> (7\/1\/2019 to 43647), use:<\/p>\n\n\n\n Cdbl ([yourdate])<\/p>\n\n\n\n ———————————–<\/p>\n\n\n\n To convert a date in the<\/strong> serial number format to date\/time format<\/strong> (43647 to 7\/1\/2019), use:<\/p>\n\n\n\n Cdate ([yourdate])<\/p>\n\n\n\n ———————————–<\/p>\n\n\n\n To convert a text or string date<\/strong> to the date\/time format, try:<\/p>\n\n\n\n DateValue ([yourdate])<\/p>\n\n\n\n ———————————–<\/p>\n\n\n\n To convert a date to the first day of the month<\/strong>:<\/p>\n\n\n\n DateSerial (year([yourdate]),month([yourdate]),1)<\/p>\n\n\n\n ———————————-<\/p>\n\n\n\n To convert a date to the last day of the month<\/strong>:<\/p>\n\n\n\n DateSerial (year([yourdate]),month([yourdate])+1,1)-1<\/p>\n\n\n\n ———————————-<\/p>\n\n\n\n You can also convert<\/strong> a<\/strong> date\/timeformat to a string<\/strong> – here is one example:<\/p>\n\n\n\n Format([yourdate],”mmmmyyyy”)<\/p>\n\n\n\n This would render 7\/1\/19 in your date field as July2019.<\/p>\n\n\n\n\n\n More information on the Format function and syntax can be found on the Microsoft Office Support site<\/a>. <\/p>\n\n\n\n Please feel free to contact me or comment if there are other short tutorials\/how-to articles you would like to see. I’d love to help you out.<\/p>\n\n\n\n If I helped you, please consider leaving a tip via PayPal to support the blog! Thanks!! <\/b><\/p>