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

 

Thanks Bill and John for your replies!

Following Bill's instruction, I converted Access Date into SQL Server Datetime2(0). On final queries which are used for forms or reports, I formatted via Format([aaaa]![bbbb],"mm/dd/yyyy"), and it works.

For date calculation, Access' formula Now() - [Datethen] can not be converted into SQLServer. But when I use DateDiff(Date() - [Datethen]), and it works.  It seems to me I have to use DateDiff for SQL Server, rather than just a simple subtraction as in Access.

Thanks again for helping all of us!

Tim

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (12)

Visit Your Group

• New Members 4

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___