Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I'm trying to create the following expression which contains a variable but I'm getting syntax error
Sum({$<Fecha = {"<=Today()-"$(vNumDias)}> Ventas)
What is the correct way to include the variable?
Thanks
T
Hi,
Have a look at the attached application.
Regards,
Kaushik Solanki
Hi,
Try this
Sum({$<Fecha = {"<=$(=Today())-$(vNumDias)"}> Ventas)
Regards,
Kaushik Solanki
It does not work
Try this:
Sum({$<Fecha = {"<=(Today()-$(vNumDias))"}> Ventas)
HTH
Sushil
Hi,
What is the format of date in Fecha field?
if its DD/MM/YYYY then try below expression.
Sum({$<Fecha = {"<=$(=date(Today()-$(vNumDias),'DD/MM/YYYY'))"}> Ventas)
Regards,
Kaushik Solanki
Thanks a lot for your answers although unfortunately they didn't work,, I'm attaching qvw
Prueba con esto.
Sum({$<Fecha = {"$(='<='&DATE(Today()-$(vNumDias),'DD/MM/YYYY')"}> Ventas)
Saludos
Hi,
Have a look at the attached application.
Regards,
Kaushik Solanki