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.
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