Issue using Dates for relevant setting

[AndrewHargreaves]

Hi Group,

I have a use case whereby I'm attempting to build a survey to document defective Water Hydrants manufactured between 2006 and 2011. I determined that the below statement works successfully to constrain dates to between 2006 and 2012:

. > date('2006-01-01') and . < date('2012-01-01')

However, when I try to use the same statement as a relevant statement to open up other questions it fails:

${date_manufacture} = . > date('2006-01-01') and . < date('2012-01-01')

Example XLS attached.

Thanks

[IsmaelChivite]

Hi,

this worked for me: (${date_manufacture} > date('2006-01-01')) and (${date_manufacture} < date('2012-01-01'))