Hi, All--
I obtained from online a function (DateAddW) that returns a dateadd based on weekdays only. Although it seems to work, it's format seems to be other than a regular date. I get a date and time returned (the sourse field in the function is formated with data and time). However, it doesn't seem to have any actual format, date or otherwise. For example, I use a "between" dates criteria, nothing is returned. When I try to change the format in properties , I am given no options. I can add a "format" function to this function, and a date willl be returned but it still doesn't respond correctly to the date criteria. For example, I had 10/1/12 and 10/31/12 as my date range, and my return was records of October in 2011!
I've included the function as an attachment.
Any ideas?
Thanks!
Paul
I obtained from online a function (DateAddW) that returns a dateadd based on weekdays only. Although it seems to work, it's format seems to be other than a regular date. I get a date and time returned (the sourse field in the function is formated with data and time). However, it doesn't seem to have any actual format, date or otherwise. For example, I use a "between" dates criteria, nothing is returned. When I try to change the format in properties , I am given no options. I can add a "format" function to this function, and a date willl be returned but it still doesn't respond correctly to the date criteria. For example, I had 10/1/12 and 10/31/12 as my date range, and my return was records of October in 2011!
I've included the function as an attachment.
Any ideas?
Thanks!
Paul
