How has this never been fixed? (1 Viewer)

Gasman · Mar 8, 2019

On another forum, someone was stating that the weekday element of the DateAdd function did not work correctly?

Sure enough

? dateadd("w",2,date())

produces for me 10/03/2019, not 12/03/2019 ??:banghead:

May as well just use the "d" parameter?

https://support.office.com/en-us/article/DateAdd-Function-63BEFDF6-1FFA-4357-9424-61E8C57AFC19

June7 · Mar 8, 2019

That link doesn't work for me - 'page not found'. Here it is.

https://support.office.com/en-us/article/DateAdd-Function-63BEFDF6-1FFA-4357-9424-61E8C57AFC19

I was hoping it would not include weekends when adding days but unfortunately "w" does return same as "d".

Gasman · Mar 8, 2019

Thank you June7, not sure what happened there, but I updated the link.

TBH I did not even know there was a weekday option as I have seen plenty of home made versions here?

June7 · Mar 8, 2019

Lots of homemade options because they want to count days and exclude weekends and holidays.

Gasman · Mar 8, 2019

June7 said:
Lots of homemade options because they want to count days and exclude weekends and holidays.

I realise that, but surely that function (if it worked) and a DCount of dates in holiday table would be so much easier?

plog · Mar 8, 2019

Why's it documented? That's the 3rd most stupidest thing about this. Not working is first, not taking it out because it doesn't is second. But if your too lazy to do those things, surely you can be even more lazy and not document it so people don't find out about it and expect it to work.

June7 · Mar 8, 2019

Agree - if it worked.

Also interesting that 'w' interval in DatePart() returns same as Weekday().

CJ_London · Mar 9, 2019

I think you'll find 'weekday' means 'dayoftheweek', it does not mean Mon-Fri, it is Mon-Sun so in that context it will be the same as 'day'

June7 · Mar 9, 2019

I know that, just found it interesting that DatePart("w",Date()) and Weekday(Date()) return the same output. Two ways to get same thing and unrelated to original question except to point out that the constant "w" has some purpose somewhere.

How has this never been fixed? (1 Viewer)

Gasman

Enthusiastic Amateur

June7

AWF VIP

Gasman

Enthusiastic Amateur

June7

AWF VIP

Gasman

Enthusiastic Amateur

plog

Banishment Pending

June7

AWF VIP

CJ_London

Super Moderator

June7

AWF VIP

Similar threads

Users who are viewing this thread