Files with variable date stamps in the file name

[DougHeller]

I need to open an excel spreadsheet and populate it with data on a daily basis in a new process.  However, the spreadsheet name has a numeric month and year format embedded in the name (ex:  PriceData 09 2018.xlsm). Is it possible to code this as variables for Blue Prism to determine the month and year numerically and then to insert into the file name value via Expression Chooser? Thx. Doug

[MetVonghiran]

Hello Doug   Yes you could.    FormatDate(Today(), ""MM yyyy"") this should give you, 10 2018 (in my timezone Today that is) then you can put this in ""Open Workbook"" ""PriceData ""&FormatDate(Today(), ""MM yyyy"")&"".xlsm""    Please note that it would be good to have both the filename, extension and the date logic in Data Item for better visibility.   Regards, Met Vonghiran

[DougHeller]

Thank you, Met!  I will definately give that a try.