We have 2 report parameters start date and end date. If user enters start date then the end date should be calculated based on the start date and vice versa. For example

startdate = 2024-03-01 00:00:00.000 then end date should be 2024-03-31 23:59:59.998

I tried something like below however it doesn’t work, In the below case user enters end date and the start date should be calculated automatically based on end date.

if(params["startdate"].value && params["enddate"].value == null)
{
endDate = MXReportSqlFormat.getEndDayTimestampFunction(params["endDate"])
startDate = new Date(endDate.getFullYear(), endDate.getMonth(), 1)
where  += " and a.actualdate >= " + startDate
}