Avatar of sannunzi

asked on 

Formatting a date field in an excel macro

I have an excel macro that is pulling data from an access query, but my result fields that are dates that are going into an excel worksheet  are coming in as a number and not a date.  What syntax do you use to format the field in the vba select statement?  Example field name IDWS.Date_On
Microsoft Access

Avatar of undefined
Last Comment

8/22/2022 - Mon