new_date - old_date = how many day ?

Hi,
How to find how many day between dates?
Sorry for my english :)

Thanks

Nov 20 '05 #1

1088

DateDiff(DateInterval.Day, oldestdate, latestdate)

eric

"skech" <sk***@seker.zzn.com.bunu_sil> wrote in message
news:%2******************@TK2MSFTNGP09.phx.gbl...

Hi,
How to find how many day between dates?
Sorry for my english :)

Thanks

Nov 20 '05 #2

Armin Zingler

"skech" <sk***@seker.zzn.com.bunu_sil> schrieb

Hi,
How to find how many day between dates?
Depends on how you define "between" and how the time-of-day should be
handled.

dim ts as timespan
dim d1, d2 as date
d1 = #10/18/2003#
d2 = #10/16/2003#
ts = d2.subtract(d1)

The Timespan will return 2 days difference, whereas there's only 1 day
between the two days.
Sorry for my english :)

Sorry for mine, too. ;)
--
Armin

Nov 20 '05 #3

Hemanth

Hi

DATEDIFF(DAY, old_date, new_date) will give the number of days
Similarly DATEDIFF(MONTH, old_date, new_date) will give the number of
months.

Hemanth

"skech" <sk***@seker.zzn.com.bunu_sil> wrote in message
news:#J**************@TK2MSFTNGP09.phx.gbl...

Hi,
How to find how many day between dates?
Sorry for my english :)

Thanks

Nov 20 '05 #4

Similar topics

Many-Many vs Object Relational

by: Mikey | last post by:

Hi all. In the process of trying to figure this thing out, I've been doing the old "stand around in the store and read as much as possible before you look like a derelict" thing. This time, with...

MySQL Database

Help with Many-to-Many-to-Many Problem

by: Keith | last post by:

I am having a problem creating a many-to-many-to-many type relationship. It works fine, but when I create a view to query it and test it, it does not generate the results I expected. Below...

Microsoft SQL Server

many-to-many XML structure

by: oNLINE bUDDY | last post by:

How can you reverse a many-to-many XML structure between 2 tags? Lets say we have a books/author XML file. A book can have many authors. <book1> <Author1> </Author1> </book1>

.NET Framework

Many to Many Relationships- How far is too far?

by: Megan | last post by:

hello everybody, i know this is a very long post, but i wanted to provide as much detail as possible. quick overview- i want to create a couple of many to many relationships and am wondering...

Microsoft Access / VBA

The Many-to-Many Relationship

by: Johnny Meredith | last post by:

Hi, I'm building a database that, once a year, generates surveys that are emailed to people in our organization. The recipients of the surveys are managers of various departments. The emails...

Microsoft Access / VBA

Many to Many query help!

by: Phil W | last post by:

Hello, I have set up my database in access using many to many relationships (it's the good ol' books and authors one again). I've actually extended it to include other people who contribute in...

Microsoft Access / VBA

Many to Many cOnFuSiOn

by: the other john | last post by:

The trouble currently with 3 tables. I'm excluding non-relevant fields... tbl_users PK_user_ID tbl_developers PK_developer_ID FK_developer_user_ID FK_developer_project_ID

ASP / Active Server Pages

Can't get many-to-many relationship to work

by: radiodave | last post by:

I don't know how to ask this question but I'll try: I'm making a database (Access 2003) for an Opera buff. I have tables related like: each Opera has many Productions (Madame Butterfly has an...

Microsoft Access / VBA

Data Entry Form with a Many-to-Many Relationship

by: RobertJohn | last post by:

Hi all I am using Access 2007 to start a small home library application, and so far it has two tables. 1. Books, with fields Book_ID (Primary Key) and Title, and 2. Authors, with fields...

Microsoft Access / VBA

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware