Sorry, your question is too broad.
Please start here:
https://winscp.net/eng/docs/guide_automation
https://winscp.net/eng/docs/script_download_most_recent_file#scripting
And if you have any problem, please ask a more specific question about a specific problem you encounter.

Hi,

I am extremely new to WinSCP but am looking for a way to pass a variable to a file name. I want to use WinSCP to automate a get command to retrieve the latest file in a folder from an SFTP site.

So basically it would be

Get: https:\\XXXX.com\xxxx\xxxx. I know you can use the latest command but am not quite sure how that works.

On top of that I want to grab yesterday's file as well in certain cases hence the date variable.

Any help would be appreciated.
Thanks