How to add a current date as suffix while using copy?

databicky
Contributor II

how to add a current date after filename suffix while copy from the dbutils like report20221223.xlsx

dbutils.fs.cp('dbfs://temp/balancing/report.xlsx','abfss://con@adls/provsn/result/report.xlsx',True)

i need to add the current date in the file like report20220123.xlsx while copying from source to target location

how can we add a current date after the suffix in filename while using dbutils.​