Toad World® Forums

Setting up email with attachment of most recent file

Is there a way (TDP 3.2) to set up the send email function to send a file from a specific folder, but have it pick only the most current file? (Note these files have the date tag on the file name file_name_yyyy-mm-ddd.xlsx). If so, how?

Should be able to use a variable to get the correct file name. Something like

concat(concat(‘file_name_’, to_char(current_date(),‘YYYY-MM-DD’)), ‘.xlsx’)

Not sure why you have 3 D’s on your format. You could get the three-char day with DY instead of DD if that’s what you need.