[AccessD] DateDiff or other function

You need to specify the FirstWeekOfYear...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.

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

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
paul.hartland at fsmail.net
Sent: Tuesday, July 13, 2004 10:38 AM
To: accessd
Subject: [AccessD] DateDiff or other function


To all,
 
Our financial year starts at 1st April and all I'm trying to do is get the
number of weeks between 1st April and any date a user types in.  I have just
played with datediff for around 30 minutes using something similar to
intWeeks = Datediff("ww",01/04/04,Me.txtDate) I used 12/07/04 for the
me.txtDate which is around 16 weeks but I'm getting 28.  Can someone tell me
where I can find the answer or send me an example of how to do this please.
 
Thanks in advance for any help.
 
Paul Hartland

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at:
http://www.wanadoo.co.uk/help/id/7098.htm
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com