SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,770 questions
How to get a date of day in current week
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 43%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Spunny
326
Reputation points
Hi,
I have table that stores configurations like
In my sql code, I need to take currentDateTime and get
- current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024.
- Get following week wednesday date. Here it will be 10-09-2024
- Get CutOffDate for that current week cutoffday (which is Friday). So, for this week it will be 10-04-2024
- Then I need to see if currentdatetime (now) is less than cutoffdatetime (10-04-2024 17:00:00) if it is less than, then I should get
Following Wednesday as nextexecution date should be following wednesday(10/09/2024) ```1. If currentdatetime > cuttoffdatetime (10-04-2024 17:00:00), for example currentdateTime is 10-04-2024 18:30:00) Then nextexecutiondate should be 2 weeks wednesday which is 10-16-2024.
Our sever is set up default to Sunday as start of the week.
How do I achieve this.
TIA.
{count} votes
-
Erland Sommarskog 111.1K Reputation points2024-10-02T18:47:00.79+00:00 Your post is not particularly clear. In point 2 you say you should get the Wednessay in the following week, and give the 9th as an example. Then in point 3, you say cutoffday for that week and it is a Friday, but you say that would be the 4th, and not the 11th.
We would also need to know what happens if the current day is a Monday, a Thursday, a Saturday etc.
Sign in to comment
Sign in to answer