F
FBxiii
I am using the DateAdd function to try and calculate weekly figures.
we: DateAdd("d",-Weekday([Received])+6,[Received])
This is showing Fridays date and I want the week ending to be on a Sunday so
am using +8 which gives me the right date.
For some reason though, some figures are leaking through to the following
week and I cant figure out how to stop it.
e.g. we = 22/06/08 Received = 15/06/08
The 15/06/08 is a Sunday and should be counted in the Previous weeks 'we'
date. Can anyone tell me whats going wrong please?
Cheers,
Steve.
we: DateAdd("d",-Weekday([Received])+6,[Received])
This is showing Fridays date and I want the week ending to be on a Sunday so
am using +8 which gives me the right date.
For some reason though, some figures are leaking through to the following
week and I cant figure out how to stop it.
e.g. we = 22/06/08 Received = 15/06/08
The 15/06/08 is a Sunday and should be counted in the Previous weeks 'we'
date. Can anyone tell me whats going wrong please?
Cheers,
Steve.