Really just throwing a suggestion out there for Epicor. It would be nice to add to the execution settings the ability to specify a value for DATEFIRST. If this is already possible can someone let me know.
Thanks.
Interesting. So looking to use Monday as first day of the week instead of the SQL default of Sunday?
I wonder about impact of this on any reports or the like that may use DatePart - I assume that’s what you are trying to do is change to use that with a different value?
Correct, so the query actually would reflect Monday as being the first day of the week, rather than Sunday (the SQL default).
Where are you trying to stitch this in? In a bpm widget, c# code, a BAQ…
BAQ.
So, if I want to run a query and group by week number, the week numbers do not match our payroll calendar because our calendar runs Monday to Sunday, not Sunday to Saturday.
I can do this in SQL with DATEFIRST.
As you can see in this screenshot, I get two different results when I am able to set DATEFIRST in SSMS. The ReqDueDate on this job is Monday 05/08/2017
1 Like
Sounds like time to contact your friendly neighborhood Epicor Rep with a request.
Good scenario!
FYI - I would love to capture these kinds of scenarios personally and enter them but when you folks contact support and go through the process it gets rated higher in our queue since it came from a customer 
1 Like