datediff problem

[sdel_nevo]

Hi Guys

I think I might be doing something really silly here the problem I have is this

when trying to work out the days between to dates using this



DateDiff("d", [Forms]![UnexCapacityDatesSelectionForm]![StartDate], [Forms]![UnexCapacityDatesSelectionForm]![EndDate])
this gives the number of days including weekend

replacing with this
DateDiff("w", [Forms]![UnexCapacityDatesSelectionForm]![StartDate], [Forms]![UnexCapacityDatesSelectionForm]![EndDate])

or this
DateDiff("ww", [Forms]![UnexCapacityDatesSelectionForm]![StartDate], [Forms]![UnexCapacityDatesSelectionForm]![EndDate])

returns the same value?

am I right in thinking that "W" = weekdays and "WW" = Weeks between the two dates
if this is correct has anyone got any idea why it's not working and returning the same figure for both.

many thanks

Steve

[orange]

There are some functions and dialogs at this link that may be useful to you.
http://www.access-programmers.co.uk/...d.php?t=133329

[sdel_nevo]

Hi Orange

many thanks

will look into these links
many thanks again

Steve

[June7]

"w" and "ww" return the same results. So no, "w" does not mean weekdays. There is no intrinsic function or parameter that will ignore weekends and holidays when counting days. This requires custom VBA function. Common topic.

[sdel_nevo]

Hi June

Thanks for the reply, I have studied the links that orange sent over and have used this information to get the results I required.

I'm slowly getting to grips with vba whilst at times it can be extreamly frustrating I have to say that on the whole I have really enjoyed the challenge.

Many thanks again
Steve

[orange]

@Steve
Glad you have resolved the issue.
vba can be frustrating, but make sure you have a clear statement/understanding of WHAT you are trying to accomplish.
You can always get help in this forum if you have given an honest try, and ask a clear question(s).

Good luck.