Date variable not working on comparation in set analysis

Anonymous — Sat, 16 Nov 2024 21:41:06 GMT

Hi all,

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

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)

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'

Re: Date variable not working on comparation in set analysis

nithin149 — Thu, 27 Dec 2018 21:34:29 GMT

Try this,

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