Actually this is weekly challenge #241 .
But I want to solve it using Macro Textbox to set the end date.
Change the mode from update value with formula to update value/replace specific string. set the string to be 2024-07-02.
After testing you will see that this macro isn't all that useful - what you want is something which takes in a value from a datafield (maybe) - if so change the text box to a control parameter.
Thanks for your reply..
I will look for another solution based on you recommendation.