Forum Discussion
Calculated Date Formula Error
when select this month, then the date is from the first day to today. However, you change the date, then the conditon conflicts with "This Month". The same as Last Month. So I think you can separate to 2 pages. One is for fixed period. The other is for mannually selection.
Hi ryan_mayu,
Ye correct. But here the issue is that once I change the date, either in the Start or end date, then the duration filter is not working. So if I am manually changing the date to, let's say 12 June, and then when I am selecting last month, it is not filtering the date between 1 May and 31 May. And the user might sometimes change the date manually.
when select this month, then the date is from the first day to today. However, you change the date, then the conditon conflicts with "This Month". The same as Last Month. So I think you can separate to 2 pages. One is for fixed period. The other is for mannually selection.