[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