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

[databicky]

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.​

[Aviral-Bhardwaj]

This will give you a little bit more idea

import time
 
timestr = time.strftime("%Y%m%d-%H%M%S")
 
print(timestr)

Now you can use formator and implement this solution

Thanks

Aviral

[Chaitanya_Raju · Accepted solution]

@Mohammed sadamusean​ hope the below code might help you,

from datetime import datetime
date_value = datetime.now().strftime("%Y%m%d")
 
src = 'dbfs:/FileStore/Test/File.csv'
trgt = f'dbfs:/FileStore/Test/File_{date_value}.csv' 
 
dbutils.fs.cp(src,trgt)

Happy Learning!!

[databicky]

how can we get the data without hyphen​

[Chaitanya_Raju]

You can try like below

from datetime import datetime
datevalue = datetime.now().strftime("%Y%m%d")
 
src = 'dbfs:/FileStore/Test/File.csv'
trgt = f'dbfs:/FileStore/Test/File{datevalue}.csv' 
 
dbutils.fs.cp(src,trgt)
 
 

Happy Learning!!

[Kaniz]

Hi @Mohammed sadamusean​, We haven’t heard from you since the last response from @Aviral Bhardwaj​ and @Ratna Chaitanya Raju Bandaru​, and I was checking back to see if their suggestions helped you.

Or else, If you have any solution, please do share that with the community as it can be helpful to others.

Also, Please don't forget to click on the "Select As Best" button whenever the information provided helps resolve your question.