I am totally frustrated trying to use the weekday function in a statement thus: <br>
Day% = Weekday(ThisMonth%/1/ ThisYear%)<br>
<br>
I get Day% = 7 (should be 4) when ThisMonth% = 3 and ThisYear% = 2000 (values checked with Breakpoint on next line). What the #$%@# gives with this thing?<br>
<br>
(Have tried putting the date expression into a variant and then performing Weekday on variant, putting #'s outside the expression, using commas instead of /'s)<br>
<br>
Any insight into this glitch will be greatly appreciated!<br>
<br>
Jeff Roberts
Day% = Weekday(ThisMonth%/1/ ThisYear%)<br>
<br>
I get Day% = 7 (should be 4) when ThisMonth% = 3 and ThisYear% = 2000 (values checked with Breakpoint on next line). What the #$%@# gives with this thing?<br>
<br>
(Have tried putting the date expression into a variant and then performing Weekday on variant, putting #'s outside the expression, using commas instead of /'s)<br>
<br>
Any insight into this glitch will be greatly appreciated!<br>
<br>
Jeff Roberts