Q: How to get the period between two dates?
Well i looked over your whole site and couldn't find this. I was
wondering if there is a way to make it display the days of the year ( i
know how to make it do it by month just put & Day(Now) &, what i mean is like today is the 65 day of the year). i was wondering how to do this because i want to make a program that will count down to the year 2000.


Soccer5099@aol.com


A:
yes it's a VB command called DateDiff which can do this. It's 
shows the days (weeks,years whatever you want I thought even 
hours and minutes) from a certain dat to another date. 

- from the VB Help file -
DateDiff Function

Returns a Variant (Long) specifying the number of time intervals between two specified dates.

Syntax

DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])

The DateDiff function syntax has these named arguments:

Part		Description
interval	Required. String expression that is the interval of time you use to calculate the difference between date1 and date2.
date1, date2	Required; Variant (Date). Two dates you want to use in the calculation.
firstdayofweek	Optional. A constant that specifies the first day of the week. If not specified, Sunday is assumed.
firstweekofyear	Optional. A constant that specifies the first week of the year. If not specified, the first week is assumed to be the week in which January 1 occurs.
Settings

The interval argument has these settings:

Setting	Description
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second



Return