defining months to use in calculation

Forum|Forum|3 years ago
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";
	}
}

M

MorisMonkAccepted solution

Level 4

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