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!!