DateDiff

[Rhys Davies]

Hi - im being a bit slow this monday morning so if someone could please help
then that would be great!

i have fullpaydateto and fullpaydatefrom where i enter the dates that the
person is to be off on full pay e.g. 01/09/2007 , 28/09/2007.

i then have a field called fullpaynoweeks where i want it to display the
number of weeks that the user will be off for based on the dates entered in
the fields above on exit of fullpaydatefrom. My code is below but doesnt
work, me!fullpaynoweeks - null in VBA when debugging.
Me!fullpaynoweeks = DateDiff(w, [fullpaydateto], [fullpaydatefrom])

Thanks,

Rhys.

 

[Maurice]

Try this

Me!fullpaynoweeks = DateDiff("w", [fullpaydateto], [fullpaydatefrom])

hth

 

[Rhys Davies]

aagh - flamin quotation marks!

thanks!

Try this

Me!fullpaynoweeks = DateDiff("w", [fullpaydateto], [fullpaydatefrom])

hth
--
Maurice Ausum

Hi - im being a bit slow this monday morning so if someone could please help
then that would be great!

i have fullpaydateto and fullpaydatefrom where i enter the dates that the
person is to be off on full pay e.g. 01/09/2007 , 28/09/2007.

i then have a field called fullpaynoweeks where i want it to display the
number of weeks that the user will be off for based on the dates entered in
the fields above on exit of fullpaydatefrom. My code is below but doesnt
work, me!fullpaynoweeks - null in VBA when debugging.
Me!fullpaynoweeks = DateDiff(w, [fullpaydateto], [fullpaydatefrom])

Thanks,

Rhys.