How can i use the custom date instead of current date to achieve the below functionality. Goal is to use between and coalesce in date filtering. Can any one suggest me a way to achieve this.
DateExpression dateParam = Expressions.currentDate();
dateParam.between(qEntity1.startDate, qEntity.endDate.coalesce(dateParam)));
Thanks