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.
does that mean if you select last month, the start date and end date will be 5/1-5/31， if you select current month, the start date and end date will be 6/1 - today?
then why you mannually change the start date and end date?
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.