Record selection based on Next Sunday through end of 2 months out
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
I want to pull all records from the {@Calc Promise Date} field that have a date range of next Sunday through the end of next month. I have the end of next month part, and tried the next Sunday part using some similar examples on this site, but I am still off target on the next Sunday part.
Original try that would have a start of 5 days after today:
{@Calc Promise Date}>=DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+5)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
This was modified from help given to another user, but does not cover how to adjust the start date of the range to next Sunday.
I tried the following and have errors as I do not understand the correct layout, or if this will help in getting my desired start date.
{@Calc Promise Date} >= if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
crystal-reports
edited Nov 16 '18 at 15:59
4444
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
add a comment |
0
I want to pull all records from the {@Calc Promise Date} field that have a date range of next Sunday through the end of next month. I have the end of next month part, and tried the next Sunday part using some similar examples on this site, but I am still off target on the next Sunday part.
Original try that would have a start of 5 days after today:
{@Calc Promise Date}>=DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+5)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
This was modified from help given to another user, but does not cover how to adjust the start date of the range to next Sunday.
I tried the following and have errors as I do not understand the correct layout, or if this will help in getting my desired start date.
{@Calc Promise Date} >= if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
crystal-reports
edited Nov 16 '18 at 15:59
4444
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32
add a comment |
0
0
0
I want to pull all records from the {@Calc Promise Date} field that have a date range of next Sunday through the end of next month. I have the end of next month part, and tried the next Sunday part using some similar examples on this site, but I am still off target on the next Sunday part.
Original try that would have a start of 5 days after today:
{@Calc Promise Date}>=DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+5)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
This was modified from help given to another user, but does not cover how to adjust the start date of the range to next Sunday.
I tried the following and have errors as I do not understand the correct layout, or if this will help in getting my desired start date.
{@Calc Promise Date} >= if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
crystal-reports
edited Nov 16 '18 at 15:59
4444
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
I want to pull all records from the {@Calc Promise Date} field that have a date range of next Sunday through the end of next month. I have the end of next month part, and tried the next Sunday part using some similar examples on this site, but I am still off target on the next Sunday part.
Original try that would have a start of 5 days after today:
{@Calc Promise Date}>=DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+5)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
This was modified from help given to another user, but does not cover how to adjust the start date of the range to next Sunday.
I tried the following and have errors as I do not understand the correct layout, or if this will help in getting my desired start date.
{@Calc Promise Date} >= if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
crystal-reports
crystal-reports
edited Nov 16 '18 at 15:59
4444
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
edited Nov 16 '18 at 15:59
4444
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
edited Nov 16 '18 at 15:59
4444
3,33692443
edited Nov 16 '18 at 15:59
4444
3,33692443
edited Nov 16 '18 at 15:59
4444
3,33692443
3,33692443
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
asked Nov 16 '18 at 14:21
Jacqueline ReynardJacqueline Reynard
33
33
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32
add a comment |
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32
add a comment |
1 Answer
1
active
oldest
votes
0
You are almost done as per my knowledge writing this formula in Record Selection doesn't work instead create saperate formulas and write on liner in record selection.
Create a formula Start Date:
if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
Create a Formula End Date:
DateSerial(Year(currentdate),Month(currentdate)+2,1)
Now your Record Selection:
{@Calc Promise Date}>={@Start Date}
and {@Calc Promise Date}<{@End Date}
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
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
});
}
});
draft saved
draft discarded
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%2f53339668%2frecord-selection-based-on-next-sunday-through-end-of-2-months-out%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
0
You are almost done as per my knowledge writing this formula in Record Selection doesn't work instead create saperate formulas and write on liner in record selection.
Create a formula Start Date:
if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
Create a Formula End Date:
DateSerial(Year(currentdate),Month(currentdate)+2,1)
Now your Record Selection:
{@Calc Promise Date}>={@Start Date}
and {@Calc Promise Date}<{@End Date}
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
add a comment |
0
You are almost done as per my knowledge writing this formula in Record Selection doesn't work instead create saperate formulas and write on liner in record selection.
Create a formula Start Date:
if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
Create a Formula End Date:
DateSerial(Year(currentdate),Month(currentdate)+2,1)
Now your Record Selection:
{@Calc Promise Date}>={@Start Date}
and {@Calc Promise Date}<{@End Date}
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
add a comment |
0
0
0
You are almost done as per my knowledge writing this formula in Record Selection doesn't work instead create saperate formulas and write on liner in record selection.
Create a formula Start Date:
if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
Create a Formula End Date:
DateSerial(Year(currentdate),Month(currentdate)+2,1)
Now your Record Selection:
{@Calc Promise Date}>={@Start Date}
and {@Calc Promise Date}<{@End Date}
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
You are almost done as per my knowledge writing this formula in Record Selection doesn't work instead create saperate formulas and write on liner in record selection.
Create a formula Start Date:
if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 1
then DateSerial(Year(currentdate),Month(currentdate),1+7)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 2
then DateSerial(Year(currentdate),Month(currentdate),1+6)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 3
then DateSerial(Year(currentdate),Month(currentdate),1+5)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 4
then DateSerial(Year(currentdate),Month(currentdate),1+4)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 5
then DateSerial(Year(currentdate),Month(currentdate),1+3)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 6
then DateSerial(Year(currentdate),Month(currentdate),1+2)
else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),1),1) = 7
then DateSerial(Year(currentdate),Month(currentdate),1+1)
and {@Calc Promise Date}<DateSerial(Year(currentdate),Month(currentdate)+2,1)
Create a Formula End Date:
DateSerial(Year(currentdate),Month(currentdate)+2,1)
Now your Record Selection:
{@Calc Promise Date}>={@Start Date}
and {@Calc Promise Date}<{@End Date}
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
answered Nov 16 '18 at 17:41
SivaSiva
7,79182848
7,79182848
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
add a comment |
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
A huge "THANK YOU!!!". I modified the Start date a bit and am getting the desired end date selection range. if DayOfWeek (DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 1 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+7) else if DayOfWeek(DateSerial(Year(currentdate),Month(currentdate),Day(currentdate))) = 2 then DateSerial(Year(currentdate),Month(currentdate),Day(currentdate)+6) And so on
– Jacqueline Reynard
Nov 16 '18 at 18:27
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53339668%2frecord-selection-based-on-next-sunday-through-end-of-2-months-out%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
what are errors for second formula?
– Siva
Nov 16 '18 at 17:11
Thank you for looking at this. The error I get has something to do with the way I have written my selection formula. When I try to save it I get "There is an error in this formula. Do you want to save it anyway?"; followed by "A boolean is required here." and the following formula section highlighted. DateSerial(Year(currentdate),Month(currentdate),1+1)
– Jacqueline Reynard
Nov 16 '18 at 17:32