defining months to use in calculation | Community
Skip to main content
ReluctantProgrammer
ReluctantProgrammer
Level 4
July 19, 2022
Solved

defining months to use in calculation

  • July 19, 2022
  • 1 reply
  • 1433 views

Trying to take a range of month/date to utilize in calculation below...

 

var d = new Date(this.rawValue);
YearTraveled.rawValue = d.getYear()+1900

 

if (this.resolveNode("YearTraveled").rawValue == "2020") {
this.resolveNode("TravelReimbursement").rawValue = ".575";
}
if (this.resolveNode("YearTraveled").rawValue == "2021") {
this.resolveNode("TravelReimbursement").rawValue = ".560";

 

I want the next action to say...

if MonthTraveled is (July 2022 thru December 2022)

this.resolveNode("TravelReimbursement").rawValue = ".625";

 

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by MorisMonk

Try this

var d = new Date(this.rawValue);
YearTraveled.rawValue = d.getFullYear();
MonthTraveled.rawValue = d.getMonth() + 1;
TravelReimbursement.rawValue = "";

if (YearTraveled.rawValue == "2020") {
	TravelReimbursement.rawValue = ".575";
	
} else if (YearTraveled.rawValue == "2021") {
	TravelReimbursement.rawValue = ".560";
	
} else if (YearTraveled.rawValue == "2022") {
	if ((MonthTraveled.rawValue >= 7) && (MonthTraveled.rawValue <= 12)) {
		TravelReimbursement.rawValue = ".625";
	}
}

1 reply

M
MorisMonkAccepted solution
Level 4
July 20, 2022

Try this

var d = new Date(this.rawValue);
YearTraveled.rawValue = d.getFullYear();
MonthTraveled.rawValue = d.getMonth() + 1;
TravelReimbursement.rawValue = "";

if (YearTraveled.rawValue == "2020") {
	TravelReimbursement.rawValue = ".575";
	
} else if (YearTraveled.rawValue == "2021") {
	TravelReimbursement.rawValue = ".560";
	
} else if (YearTraveled.rawValue == "2022") {
	if ((MonthTraveled.rawValue >= 7) && (MonthTraveled.rawValue <= 12)) {
		TravelReimbursement.rawValue = ".625";
	}
}
    ReluctantProgrammer
    ReluctantProgrammerAuthor
    Level 4
    July 25, 2022

    Made a slight change and it worked....

     

     

    var d = new Date(this.rawValue);
    YearTraveled.rawValue = d.getYear()+1900;
    MonthTraveled.rawValue = d.getMonth() +1;
    TravelReimbursement.rawValue = "";

    if (YearTraveled.rawValue == "2020") {
    TravelReimbursement.rawValue = ".575";
    }
    else if (YearTraveled.rawValue == "2021") {
    TravelReimbursement.rawValue = ".560";
    }
    else if ((YearTraveled.rawValue == "2022") && (MonthTraveled.rawValue <= 6)) {
    TravelReimbursement.rawValue = ".585";
    }
    else if ((YearTraveled.rawValue == "2022") && (MonthTraveled.rawValue >= 7)) {
    TravelReimbursement.rawValue = ".625";
    }

     

    Team work...  🙂    thanks for your help!

      Terms & ConditionsAccessibility statement

      Loading footer...