Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hy guys.
I would like to show in a table last 7 days calculated from today.
So , my table I would like to look something like this:
Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday(today) |
---|---|---|---|---|---|---|
21/09/2016 | 22/09/2016 | 23/09/2016 | 24/09/2016 | 25/09/2016 | 26/09/2016 | 27/09/2016 |
And I would like to have the option to select them to filter after the date I selected.
How can I do this?
Thank you.
Hey there,
Check out this document from community:
Selecting Arbitrary Date Ranges
Best regards,
D.A. MB
Could you post an screenshot of this error plz?
I solved my problem by writing this expression:
if(((DATE>GetFieldSelections(DATE)-7) & (DATE> GetFieldSelections(DATE))),WeekDay(DATE) & ' ' & DATE)