i would like some help with finding records within date range.
I would like to check if date field is within last 6 months from todays date. If true set check field to 1 or of false set field to 0.
I have tried with IF and Case but it seams like they dont work with range.
my calculation looks like this:
Case (record checked=GetAsText(Get( CurrentDate ) - 183 ) & "..." & GetAsText(Get( CurrentDate ) - 1 );1;0)
But it always return 0
What do i do wrong