Steve Bowman
MIS
Kind of strange thing going on
I have never really needed to mess around much with DOW() it always pretty much worked for me as is and I use it very often. However, I have run into a situation where I need to change from a Sunday through Saturday calendar period to a Monday through Sunday period. I was excited to use something new. So I SET FDOW 2 and tested on today 11/09/2023 (a Thursday) and the result was 5 not the expected 4. I then tested the same date but using DOW({11/09/2023},2) and got the correct result of 4. Am I missing something here or is there some issue with SET FDOW I am not seeing?
I would need to review many lines of code if I need to modify any DOW() functions used where SET FDOW would handle throughout with 1 line.
Steve Bowman
Independent Technology, Inc.
CA, USA
I have never really needed to mess around much with DOW() it always pretty much worked for me as is and I use it very often. However, I have run into a situation where I need to change from a Sunday through Saturday calendar period to a Monday through Sunday period. I was excited to use something new. So I SET FDOW 2 and tested on today 11/09/2023 (a Thursday) and the result was 5 not the expected 4. I then tested the same date but using DOW({11/09/2023},2) and got the correct result of 4. Am I missing something here or is there some issue with SET FDOW I am not seeing?
I would need to review many lines of code if I need to modify any DOW() functions used where SET FDOW would handle throughout with 1 line.
Steve Bowman
Independent Technology, Inc.
CA, USA