How can i select date from last six months including current date.
I am using .>=today()-180 in constraint but getting selected past date with future date
How can i select date from last six months including current date.
I am using .>=today()-180 in constraint but getting selected past date with future date
Hi @Bhupender_Bhutani
You need to use decimal-date-time() function first to convert current date to number of days since January 1, 1970 then you can use something like:
. > decimal-date-time(today())-180 and . <= today()