Variables in an expression! HELP !!

[karina89]

Hello everyone!

I need to get the data from a previous day to my initial date, which have a variable (vFechaInicial).

The following expression runs but when I have a field (FechaInformacion):

Max ({<FechaInformación = { "<$ (= max (FechaInformación))"}>} FechaInformación)

But when I try to get my Variable I get error:

Anyone know where I'm wrong, or if I need to add something?

  I appreciate very much your help and your answers!

[sunny_talwar]

What is your variable containing? If it is a field name, then regardless of any error, you should get expected output. But if it is an expression, this may or may not work.

Best,

Sunny

[maksim_senin]

Hi Karina,

It's hard to help without a sample. In case you expect to have different prev. dates for each row this will hardly work since (a.f.a.i.u.) set analysis applies to a chart in a whole and cannot vary its outcome from row to row.

Best regards,

Maxim

[karina89]

Hello!!

What I want is to get the day before, to the day I have stored in my variable ( vFechaInicial )
That means if my variables have stored the following date: 19/02/2016 What I Get serious : 02/18/2016

I need an expression to help me get that result Using variables In it , I had thought to put so :

     But I make a mistake and I do not need to add or correct .

Or if anyone knows that otherwise could get what I want I would greatly appreciate your support

[bertinabel · Accepted solution]

If not achieve understand what you need.

already you tried the following?

= Date (vFechaInicial-1, 'DD / MM / YYYY')

in this case defined the vFechaInicial variable with the value 02/19/2016

- - -

No se si logre entender bien lo que necesitas.

ya intentaste lo siguiente?

=Date(vFechaInicial-1,'DD/MM/YYYY')

en este caso defini la variable vFechaInicial con el valor de 19/02/2016

Note: English translation provided by a Community Moderator as a courtesy. Please post in English while in main forums.

[karina89]

Thank you very much, if I run, just one more question.

If you would like to take the year or the month before my date, as might represent?

Muucho appreciate your help!

- - -

Muchas gracias, si me funciono , solo una pregunta mas.
Si quisiera tomar el año o el mes anterior a mi fecha, Como podría representarlo?

Agradezco muucho tu ayuda!

Note: English translation provided by a Community Moderator as a courtesy. Please post in English while in main forums.

[bertinabel]

Hi, Karina.

     For the previous month :

     =Date (Addmonths(vFechaInicial,-1), 'DD/MM/YYYY')

     For the previous year.

     =Date (AddYears(vFechaInicial,-1), 'DD/MM/YYYY')

Regards.