Move the Date Forward in a Table

[alutz54]

Hi all, I have a table that calculates  aging analysis for the current date. I want to create a button that moves the date forward so that we can see the aging analysis for next week or next month or whatever the end user wants.

Here is what my table looks like now (actual data removed for privacy):

I have tried messing with alternate states but I cannot figure out how to get a button to work that changes a single chart between two states. Is there any way I can use a button that has to values, one that is essentially makes the sheet date equal to today() and one that makes the sheet date equal to today() plus X amount of days?

Even better if I can get the date to just change for the specific table I have.

Thanks for reading and potentially helping!

[MatheusC]

Hello, @alutz54 
I don't know if I can understand the Variable input object much better, I can help you with that. I would create a variable to store the states.

ex: variable vdata: Date(today())

within the button options would mention the desired states as example below:

When calling the states, mention the master item $(vdata)

See if it helps you

[alutz54]

That would probably work if the data was actually in date format, but after asking the question I realized that my data is not in date format so using date manipulation functions in the expressions probably won't work. I am trying to figure out how to do it in my data load editor first.