<div>
Jet SQL will handle date math of this type natively, so try something like:<br />
<br />
select [mydatefield]-#1/1/1960# &nbsp;as NumberofDays from mytable;<br />

</div>


Jet SQL will handle date math of this type natively, so try something like:

select [mydatefield]-#1/1/1960#  as NumberofDays from mytable;


<div>
I am using Access to build my queries, but I am actually connected to an Oracle DB. Is this still possible?
</div>


I am using Access to build my queries, but I am actually connected to an Oracle DB. Is this still possible?

<div>
Did you try the first post #26440626 ?
</div>


<div>
Curious &nbsp;- As indicated, my 1st post should have been the correct Syntax for your scenario with Linked Tables.<br />
<br />
Did this work for you?<br />

</div>


Curious  - As indicated, my 1st post should have been the correct Syntax for your scenario with Linked Tables.

Did this work for you?


<div>
<div class="content wysiwyg-content">
I have a query where I need to calculate the number of days from January 1st 1960, based on the data pulled. <br />
<br />
For Example:<br />
<br />
December 31 1959 = -1<br />
Janurary 2nd 1960 = 1<br />
<br />
I have tried the DateDiff ('d', 01/01/1960, [tablename].[date]) , but this doesnt seem to work properly... <br />
<br />
Thanks,<br />
<br />
Brad
</div>
</div>


I have a query where I need to calculate the number of days from January 1st 1960, based on the data pulled. 

For Example:

December 31 1959 = -1
Janurary 2nd 1960 = 1

I have tried the DateDiff ('d', 01/01/1960, [tablename].[date]) , but this doesnt seem to work properly... 

Thanks,

Brad

How to calculate date in Access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.