[MS_AccessPros] Date Format Issue in Access 2013 FrontEnd and SQL Server 2012 BackEnd

 

Would any of you please advise me on this:

I use Access 2013 on the FrontEnd and use SSMA to migrate to SQL Server 2012. Everything migrated up fine except for the dates. I looked at the tables on SQL 2012 and the date column is formatted as datetime2(0). This datetime 2 include minutes and seconds next to the date. I just want the date as Date/Time in Access.

Could you show me how to format the Date/Time in Access so that SQL Server would accept it?

Thanks so much in advance!

Tim

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___