Date range logic for past dates

0

I have 3 dates: Present, Start and End.

Present date = '11/21/2018' (today's date)

Start = '10/5/2015'

End = '12/4/2019

I need to create a daterange using these dates.

I have the following code to calculate date range.

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

I need to edit this in a way where the date ranges from Present date to enddate instead of StartDate but the range itself is based on the day of startdate.

Any help is appreciated! Thank you.

javascript

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

add a comment | 

0

I have 3 dates: Present, Start and End.

Present date = '11/21/2018' (today's date)

Start = '10/5/2015'

End = '12/4/2019

I need to create a daterange using these dates.

I have the following code to calculate date range.

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

I need to edit this in a way where the date ranges from Present date to enddate instead of StartDate but the range itself is based on the day of startdate.

Any help is appreciated! Thank you.

javascript

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

add a comment | 

0

0

0

I have 3 dates: Present, Start and End.

Present date = '11/21/2018' (today's date)

Start = '10/5/2015'

End = '12/4/2019

I need to create a daterange using these dates.

I have the following code to calculate date range.

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

I need to edit this in a way where the date ranges from Present date to enddate instead of StartDate but the range itself is based on the day of startdate.

Any help is appreciated! Thank you.

javascript

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

I have 3 dates: Present, Start and End.

Present date = '11/21/2018' (today's date)

Start = '10/5/2015'

End = '12/4/2019

I need to create a daterange using these dates.

I have the following code to calculate date range.

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

I need to edit this in a way where the date ranges from Present date to enddate instead of StartDate but the range itself is based on the day of startdate.

Any help is appreciated! Thank you.

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

function createLedger(stDate, etDate) {



  if (stDate && etDate) {

    var endOfLeaseDate = moment(etDate, "MM/DD/YYYY");

    var startOfLeaseDate = moment(stDate, "MM/DD/YYYY");

    dateRange(startOfLeaseDate, endOfLeaseDate);

  }

}



function dateRange(stDate, etDate) {

  var dates = ;



  var now = stDate.clone();

  var day = stDate.date();



  while(now.isBefore(etDate)) {

    //deal with variable month end days

    var monthEnd = now.clone().endOf("month");

    if (now.date() < day && day <= monthEnd.date()) { now.date(day); }



    dates.push(now.format("YYYY-MM-DD"));

    now = now.clone().add({ "months" : 1 });

  }

  console.log(dates);

}



function RunLedgerAndPV() {

  var pDate = "11/21/2018" 

  var stDate = "10/5/2015";

  var etDate = "12/4/2019";

  createLedger(stDate, etDate);

}

RunLedgerAndPV();

<script src="https://cdnjs.cloudflare.com/ajax/libs/moment.js/2.22.2/moment.min.js"></script>

javascript

javascript

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

share|improve this question

share|improve this question

asked Nov 21 '18 at 20:22

ace23ace23

5811

asked Nov 21 '18 at 20:22

ace23ace23

5811

asked Nov 21 '18 at 20:22

ace23ace23

5811

5811

add a comment | 

add a comment | 

2 Answers
2

active

oldest

votes

0

You only need to assign today's date (formatted) to pDate.

function RunLedgerAndPV() {

    var now = new Date();

    var nowMonth = ("0" + now.getMonth()).slice(-2);

    var nowDate  = ("0" + now.getDate()).slice(-2);

    var nowYear  = now.getFullYear();



    // "11/21/2018"

    var pDate =  nowMonth + '/' + nowDate + '/' + nowYear;

    console.log(pDate);



    var stDate = "10/5/2015";

    var etDate = "12/4/2019";

    createLedger(pDate, etDate);

}

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

add a comment | 

0

Doing the following worked for me. I created a new date using start 'day' and present month and year and created an array using that day instead.

            var pastDT = stDate.getUTCDate();

            var pastMT = pDate.getUTCMonth()+2;

            var pastYR = pDT.getUTCFullYear();

            var LedgerDT = pastMT + '/' + pastDT + '/' + pastYR;



            var pastStart = presentDate > startDate;



            if (startDate && pastStart){

                var stDate = moment.utc(new Date(LedgerDT)).format("MM/DD/YYYY");

            }



            else if (startDate && !pastStart)

                var stDate = moment.utc(new Date(presentDate)).format("MM/DD/YYYY");



            var etDate = moment.utc(new Date(endDate)).format("MM/DD/YYYY");

            createLedger(stDate, etDate);

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

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
});


}
});

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53419934%2fdate-range-logic-for-past-dates%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

2 Answers
2

active

oldest

votes

2 Answers
2

active

oldest

votes

active

oldest

votes

active

oldest

votes

0

You only need to assign today's date (formatted) to pDate.

function RunLedgerAndPV() {

    var now = new Date();

    var nowMonth = ("0" + now.getMonth()).slice(-2);

    var nowDate  = ("0" + now.getDate()).slice(-2);

    var nowYear  = now.getFullYear();



    // "11/21/2018"

    var pDate =  nowMonth + '/' + nowDate + '/' + nowYear;

    console.log(pDate);



    var stDate = "10/5/2015";

    var etDate = "12/4/2019";

    createLedger(pDate, etDate);

}

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

add a comment | 

0

You only need to assign today's date (formatted) to pDate.

function RunLedgerAndPV() {

    var now = new Date();

    var nowMonth = ("0" + now.getMonth()).slice(-2);

    var nowDate  = ("0" + now.getDate()).slice(-2);

    var nowYear  = now.getFullYear();



    // "11/21/2018"

    var pDate =  nowMonth + '/' + nowDate + '/' + nowYear;

    console.log(pDate);



    var stDate = "10/5/2015";

    var etDate = "12/4/2019";

    createLedger(pDate, etDate);

}

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

add a comment | 

0

0

0

You only need to assign today's date (formatted) to pDate.

function RunLedgerAndPV() {

    var now = new Date();

    var nowMonth = ("0" + now.getMonth()).slice(-2);

    var nowDate  = ("0" + now.getDate()).slice(-2);

    var nowYear  = now.getFullYear();



    // "11/21/2018"

    var pDate =  nowMonth + '/' + nowDate + '/' + nowYear;

    console.log(pDate);



    var stDate = "10/5/2015";

    var etDate = "12/4/2019";

    createLedger(pDate, etDate);

}

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

You only need to assign today's date (formatted) to pDate.

function RunLedgerAndPV() {

    var now = new Date();

    var nowMonth = ("0" + now.getMonth()).slice(-2);

    var nowDate  = ("0" + now.getDate()).slice(-2);

    var nowYear  = now.getFullYear();



    // "11/21/2018"

    var pDate =  nowMonth + '/' + nowDate + '/' + nowYear;

    console.log(pDate);



    var stDate = "10/5/2015";

    var etDate = "12/4/2019";

    createLedger(pDate, etDate);

}

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

share|improve this answer

share|improve this answer

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

answered Nov 22 '18 at 4:00

stillatmylinuxstillatmylinux

782718

782718

add a comment | 

add a comment | 

0

Doing the following worked for me. I created a new date using start 'day' and present month and year and created an array using that day instead.

            var pastDT = stDate.getUTCDate();

            var pastMT = pDate.getUTCMonth()+2;

            var pastYR = pDT.getUTCFullYear();

            var LedgerDT = pastMT + '/' + pastDT + '/' + pastYR;



            var pastStart = presentDate > startDate;



            if (startDate && pastStart){

                var stDate = moment.utc(new Date(LedgerDT)).format("MM/DD/YYYY");

            }



            else if (startDate && !pastStart)

                var stDate = moment.utc(new Date(presentDate)).format("MM/DD/YYYY");



            var etDate = moment.utc(new Date(endDate)).format("MM/DD/YYYY");

            createLedger(stDate, etDate);

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

add a comment | 

0

Doing the following worked for me. I created a new date using start 'day' and present month and year and created an array using that day instead.

            var pastDT = stDate.getUTCDate();

            var pastMT = pDate.getUTCMonth()+2;

            var pastYR = pDT.getUTCFullYear();

            var LedgerDT = pastMT + '/' + pastDT + '/' + pastYR;



            var pastStart = presentDate > startDate;



            if (startDate && pastStart){

                var stDate = moment.utc(new Date(LedgerDT)).format("MM/DD/YYYY");

            }



            else if (startDate && !pastStart)

                var stDate = moment.utc(new Date(presentDate)).format("MM/DD/YYYY");



            var etDate = moment.utc(new Date(endDate)).format("MM/DD/YYYY");

            createLedger(stDate, etDate);

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

add a comment | 

0

0

0

Doing the following worked for me. I created a new date using start 'day' and present month and year and created an array using that day instead.

            var pastDT = stDate.getUTCDate();

            var pastMT = pDate.getUTCMonth()+2;

            var pastYR = pDT.getUTCFullYear();

            var LedgerDT = pastMT + '/' + pastDT + '/' + pastYR;



            var pastStart = presentDate > startDate;



            if (startDate && pastStart){

                var stDate = moment.utc(new Date(LedgerDT)).format("MM/DD/YYYY");

            }



            else if (startDate && !pastStart)

                var stDate = moment.utc(new Date(presentDate)).format("MM/DD/YYYY");



            var etDate = moment.utc(new Date(endDate)).format("MM/DD/YYYY");

            createLedger(stDate, etDate);

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

Doing the following worked for me. I created a new date using start 'day' and present month and year and created an array using that day instead.

            var pastDT = stDate.getUTCDate();

            var pastMT = pDate.getUTCMonth()+2;

            var pastYR = pDT.getUTCFullYear();

            var LedgerDT = pastMT + '/' + pastDT + '/' + pastYR;



            var pastStart = presentDate > startDate;



            if (startDate && pastStart){

                var stDate = moment.utc(new Date(LedgerDT)).format("MM/DD/YYYY");

            }



            else if (startDate && !pastStart)

                var stDate = moment.utc(new Date(presentDate)).format("MM/DD/YYYY");



            var etDate = moment.utc(new Date(endDate)).format("MM/DD/YYYY");

            createLedger(stDate, etDate);

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

share|improve this answer

share|improve this answer

answered Nov 26 '18 at 17:05

ace23ace23

5811

answered Nov 26 '18 at 17:05

ace23ace23

5811

answered Nov 26 '18 at 17:05

ace23ace23

5811

5811

add a comment | 

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.

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53419934%2fdate-range-logic-for-past-dates%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

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

Name

Email

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

Name

Email

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

Name

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Name

Name

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

Email

Required, but never shown

This page is only for reference, If you need detailed information, please check here