Want to select date of last six month from the current date including current 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()

1 Like