Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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
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
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
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.
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.
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.