Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys.
I have a question. Is there a way to get in expression the previous date value?
If I have these dates :
21/03/2018
20/03/2018
19/03/2018
17/03/2018
And I would like to have this result
Current | Previous |
---|---|
21/03/2018 | 20/03/2018 |
20/03/2018 | 19/03/2018 |
19/03/2018 | 17/03/2018 |
17/03/2018 | - |
Thank you,
Razvan
May be try this
=Max({<HIST_DATE = {"$(='<' & Max(HIST_DATE))"}>}HIST_DATE)
try below in strighttable
=above([Current])
Tried this solution in a Text box , but unfortunately it doesn`t work
in the script use this
if(DateCurrent <> previous(DateCurrent), DateCurrent , peek('DatePrevious' as 'DatePrevious',
try this in UI
Below(Date)
Thank you Gerold , but I specially need this in UI.
try in stright table
In TextBox, it won't work..
You have to write like in Textbox
=Concat(Aggr(ABOVE(Current), Current),', ')
I`m attaching an example.
What I especially want to do , is that I would like to show date as Label for each column.
So , for the first column should be , HIST_DATE(current selected date) , and for the second collumn is previous date.
This is where I want to show previous date
Hi,
Do you need something like this?
Saludos