SQL - Select between current week number and three weeks behind
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm not that good, when it comes to SQL. I'm trying to get data from the last three weeks. I can get the current week number, but really don't know how to subtract it so that it goes three weeks back and takes all data from that period.
This is my current code. I can make it work with a fixed number (42 in this example), but that's not what I want.
And this is what the output should be:
sql
sql-server syntax range week-number edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
add a comment |
I'm not that good, when it comes to SQL. I'm trying to get data from the last three weeks. I can get the current week number, but really don't know how to subtract it so that it goes three weeks back and takes all data from that period.
This is my current code. I can make it work with a fixed number (42 in this example), but that's not what I want.
And this is what the output should be:
sql
sql-server syntax range week-number edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
And what happens whenfldweenumis 1 or 2?
– Gordon Linoff
Nov 25 '18 at 13:11
add a comment |
I'm not that good, when it comes to SQL. I'm trying to get data from the last three weeks. I can get the current week number, but really don't know how to subtract it so that it goes three weeks back and takes all data from that period.
This is my current code. I can make it work with a fixed number (42 in this example), but that's not what I want.
And this is what the output should be:
sql
sql-server syntax range week-number edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
I'm not that good, when it comes to SQL. I'm trying to get data from the last three weeks. I can get the current week number, but really don't know how to subtract it so that it goes three weeks back and takes all data from that period.
This is my current code. I can make it work with a fixed number (42 in this example), but that's not what I want.
And this is what the output should be:
sql
sql-server syntax range week-number sql
sql-server syntax range week-number edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
edited Nov 26 '18 at 6:29
Eric Brandt
3,30011127
3,30011127
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
asked Nov 24 '18 at 22:34
Lukas Méndez DuusLukas Méndez Duus
255
255
And what happens whenfldweenumis 1 or 2?
– Gordon Linoff
Nov 25 '18 at 13:11
add a comment |
And what happens whenfldweenumis 1 or 2?
– Gordon Linoff
Nov 25 '18 at 13:11
And what happens when
fldweenum is 1 or 2?– Gordon Linoff
Nov 25 '18 at 13:11
And what happens when
fldweenum is 1 or 2?– Gordon Linoff
Nov 25 '18 at 13:11
add a comment |
1 Answer
1
active
oldest
votes
Please, avoid pictures of code....
That said, if you're using SQL Server, I believe the function you're looking for is DATEPART. See if this does what you need:
SELECT *
FROM tblData
WHERE fldWeekNum BETWEEN DATEPART(WEEK, GETDATE())-3 AND DATEPART(WEEK, GETDATE())
EDIT:
Based on the comments below, let's try subtracting 3 weeks from the current date, then getting the DATEPART for WEEK from that date. This depends on how fldWeekNum is calculated, so it may need some additional tweaking based on that.
SELECT *
FROM tblData
WHERE fldWeekNum
BETWEEN
DATEPART(WEEK,DATEADD(WEEK, -3, GETDATE()))
AND
DATEPART(WEEK, GETDATE());
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462939%2fsql-select-between-current-week-number-and-three-weeks-behind%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Please, avoid pictures of code....
That said, if you're using SQL Server, I believe the function you're looking for is DATEPART. See if this does what you need:
SELECT *
FROM tblData
WHERE fldWeekNum BETWEEN DATEPART(WEEK, GETDATE())-3 AND DATEPART(WEEK, GETDATE())
EDIT:
Based on the comments below, let's try subtracting 3 weeks from the current date, then getting the DATEPART for WEEK from that date. This depends on how fldWeekNum is calculated, so it may need some additional tweaking based on that.
SELECT *
FROM tblData
WHERE fldWeekNum
BETWEEN
DATEPART(WEEK,DATEADD(WEEK, -3, GETDATE()))
AND
DATEPART(WEEK, GETDATE());
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
add a comment |
Please, avoid pictures of code....
That said, if you're using SQL Server, I believe the function you're looking for is DATEPART. See if this does what you need:
SELECT *
FROM tblData
WHERE fldWeekNum BETWEEN DATEPART(WEEK, GETDATE())-3 AND DATEPART(WEEK, GETDATE())
EDIT:
Based on the comments below, let's try subtracting 3 weeks from the current date, then getting the DATEPART for WEEK from that date. This depends on how fldWeekNum is calculated, so it may need some additional tweaking based on that.
SELECT *
FROM tblData
WHERE fldWeekNum
BETWEEN
DATEPART(WEEK,DATEADD(WEEK, -3, GETDATE()))
AND
DATEPART(WEEK, GETDATE());
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
add a comment |
Please, avoid pictures of code....
That said, if you're using SQL Server, I believe the function you're looking for is DATEPART. See if this does what you need:
SELECT *
FROM tblData
WHERE fldWeekNum BETWEEN DATEPART(WEEK, GETDATE())-3 AND DATEPART(WEEK, GETDATE())
EDIT:
Based on the comments below, let's try subtracting 3 weeks from the current date, then getting the DATEPART for WEEK from that date. This depends on how fldWeekNum is calculated, so it may need some additional tweaking based on that.
SELECT *
FROM tblData
WHERE fldWeekNum
BETWEEN
DATEPART(WEEK,DATEADD(WEEK, -3, GETDATE()))
AND
DATEPART(WEEK, GETDATE());
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
Please, avoid pictures of code....
That said, if you're using SQL Server, I believe the function you're looking for is DATEPART. See if this does what you need:
SELECT *
FROM tblData
WHERE fldWeekNum BETWEEN DATEPART(WEEK, GETDATE())-3 AND DATEPART(WEEK, GETDATE())
EDIT:
Based on the comments below, let's try subtracting 3 weeks from the current date, then getting the DATEPART for WEEK from that date. This depends on how fldWeekNum is calculated, so it may need some additional tweaking based on that.
SELECT *
FROM tblData
WHERE fldWeekNum
BETWEEN
DATEPART(WEEK,DATEADD(WEEK, -3, GETDATE()))
AND
DATEPART(WEEK, GETDATE());
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
edited Nov 25 '18 at 4:02
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
answered Nov 24 '18 at 23:22
Eric BrandtEric Brandt
3,30011127
3,30011127
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
add a comment |
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Will this work for the first twenty days in January? I suspect it may have a problem
– Caius Jard
Nov 24 '18 at 23:51
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Yeah. I bet you’re right, @CaiusJard. I missed that, but then the week field is all that’s shown in the question, and that’ll be insufficient for spanning years.
– Eric Brandt
Nov 24 '18 at 23:55
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
Edited my answer based on @CaiusJard's comment.
– Eric Brandt
Nov 25 '18 at 4:02
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53462939%2fsql-select-between-current-week-number-and-three-weeks-behind%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
And what happens when
fldweenumis 1 or 2?– Gordon Linoff
Nov 25 '18 at 13:11