Adobe Experience Manager Forms

ReluctantProgrammer · 7/13/22

I have a formula that defines a rate based on the year...

}else if(Row2.YearTraveled.rawValue == "2022" && Row2.ddModeTransportation.rawValue == "Motorcycle"){
this.rawValue = ".605";
}

Now I need to break up this year to calculate based on time frames....1/1/22-6/30/22 is one rate and 7/1/22-12/31/22 is another.

Mayank_Gandhi · 7/14/22

@ReluctantProgrammer should be doable

var d1 = new Date(); // start date
var d2 = new Date(d1); end date

console.log(d1 == d2);   // prints false (wrong!) 
console.log(d1 === d2);  // prints false (wrong!)
console.log(d1 != d2);   // prints true  (wrong!)
console.log(d1 !== d2);  // prints true  (wrong!)

similarly you can write if else (somedate>d1 && somedate <d2) {
//do some action
}

View solution in original post

Mayank_Gandhi · 7/14/22

@ReluctantProgrammer should be doable

var d1 = new Date(); // start date
var d2 = new Date(d1); end date

console.log(d1 == d2);   // prints false (wrong!) 
console.log(d1 === d2);  // prints false (wrong!)
console.log(d1 != d2);   // prints true  (wrong!)
console.log(d1 !== d2);  // prints true  (wrong!)

similarly you can write if else (somedate>d1 && somedate <d2) {
//do some action
}

ReluctantProgrammer · 7/14/22

I will try it out...thank you

Adobe Experience Manager Forms

Using Fiscal year in calculation

Learn

Documentation

Events

Community

Support

Resources

Adobe account

Adobe