Escanaba
asked on
Access Changing Number to Date with Seperator
Hello,
Relatively new to Access and have a date column being imported from an Excel spreadsheet. The column shows the date as 1212017 (for December 1, 2017) and I need it to show as 12/1/2017 in the query. Any advice on how to make that happen? Thanks!
Relatively new to Access and have a date column being imported from an Excel spreadsheet. The column shows the date as 1212017 (for December 1, 2017) and I need it to show as 12/1/2017 in the query. Any advice on how to make that happen? Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
> 1212017 (for December 1, 2017)
and for January 21, 2017 it would be?
/gustav
and for January 21, 2017 it would be?
/gustav
ASKER
This got me where I needed to be. Thanks.
ASKER