Newbie looking for some help

Hi, I’m converting my imacros to UI.Vision and i need a little direction. Not able to find answers in the forum (maybe using wrong search words). Below is my try on converting and runs without error. I would like to further automate by looping using the date entered until the end of the month. I’m stuck on how to append the year-month-day to the end of the url in the open command target. Also pointers on how to increment the date on each iteration of the loop.

In the code below “tgitest.com” is not a valid website. When replaced with actual website it runs without error. Would like to change the Target of the Open command to the contents of the description.

{
“Name”: “RevenueReports”,
“CreationDate”: “2024-12-6”,
“Commands”: [
{
“Command”: “prompt”,
“Target”: "Revenue Reports , Enter date (yyyy-mm-dd) “,
“Value”: “ymd”,
“Description”: “”
},
{
“Command”: “open”,
“Target”: “https://tgitest.com/admin/hotel/reports/audit.cfm/mode/paymentsDetails/date/2024-11-01”,
“Value”: “”,
“Description”: “"https://tgitest.com/admin/hotel/reports/audit.cfm/mode/paymentsDetails/date/$ymd\””
},
{
“Command”: “click”,
“Target”: “xpath=//[@id="printTipsContainer"]/nav/ul/li",
“Value”: “”,
“Targets”: [
"xpath=//
[@id="printTipsContainer"]/nav/ul/li”,
“xpath=//li”,
“css=#printTipsContainer > nav > ul > li:nth-child(1)”
],
“Description”: “”
},
{
“Command”: “select”,
“Target”: “id=reportExportActions”,
“Value”: “label=Export Excel”,
“Targets”: [
“id=reportExportActions”,
“name=reportExportActions”,
“xpath=//*[@id="reportExportActions"]”,
“xpath=//select[@id=‘reportExportActions’]”,
“xpath=//select”,
“css=#reportExportActions”
],
“Description”: “”
}
]
}

Solved, have a new problem. Will be making new post.