I installed the pcik datetime. As minumum i have: NOW(“YYYY-MM-DD”)-7 and as maximum NOW(“YYYY-MM-DD”)+7 (optional is empty).
I get a date dialog but the date is from this month and on. There is no time dialog. What am I doing wrong, is this a bug or maybe device related?
I have got it working by changing the maximum date to NOW() and the minimum date to 2022-01-01. Can anyone help me out to make the minimum date like 7 days ago and the maximum date 7 days from NOW()?
Figured it out.
ADD_DURATION(NOW(), -7, “days”) and ADD_DURATION(NOW(), +7, “days”) works