Date variable not working on comparation in set analysis

[Anonymous]

Hi all,

I'm new to ClikView and I would like your help to solve a problem.

• I created a variable of Data like this:

variable1 = Date('expression',  'DD/MM/YYYY hh:mm:ss')

• When I try to use this variable to compare with another data (VCTPRO) in set analysis it doesn't work, even though they are the same:

min({<VCTPRO = {$(variable1 )}>} VALOR_PARCELA)

• But if I go to the variable and put it manually, it works fine:

variable1 = '2018-12-27 00:00:00'

• What am I doing wrong? I need the expression on the variable, I can't just use one manually, it will chenge wich time.

Obs.: The format of VCTPRO  is 'DD/MM/YYYY HH:mm:ss'

[nithin149]

Try this,

min({<VCTPRO = {'$(variable1)'}>} VALOR_PARCELA)