Create output folder everyday with today's date and write csv files into it

[nkazi01]

Hi, 

I have 7 sql scripts that I will be reading in and outputting 6 csv files from it.. 

I want to output the files in a new folder every day with the current date such as "2022-08-07"

so today's files will be saved in this path "T:/data/2022-08-07"

I also want to check if the folder is already created, then skip that step and just create my output files there. 

If folder is not there, then create the folder, and then create output files there. 

[flying008 · Accepted solution]

Hi, @nkazi01 

Maybe you can use File-Copy-Move macro of gallery to create the path first. then do you already do it.