[AccessD] DateDiff or other function

paul.hartland at fsmail.net paul.hartland at fsmail.net
Tue Jul 13 09:38:27 CDT 2004


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


More information about the AccessD mailing list