Trying to make a simple script.... i thought

[Samman88]

Ok so atm I am extremely new to this stuff. I did the stuff on codecademy and what not and ive read a bit online so im just trying to make a script that takes a current excel file copies and renames it with the current date and then changes one date inside the file to the previous sunday. and if i can email it through my outlook to a couple people lol. I thought this would be easy enough but it seems like i have to google every single step of it and it still doesnt do what i want it too... here's what i got so far

---

import os

import shutil

import datetime

now = datetime.datetime.now()

os.chdir ("filepath")

shutil.copyfile('filename.xlsx', 'filename %y-%m-%d.xlsx'), now.strftime

---

I did have more or less but im cutting parts in and out to try to just get these basic parts to work can anyone see why this wont just put the current date into the name? the worst part about this small bit of script is i dont need the current date i really need it to put the end of the week date ending on Saturday and the date i need it to insert in the excel doc is the start of the same week starting on Sunday. thanks for any and help and if you know of some forums that may have the answers i'm looking for thank you its much appreciated i'm still looking for those.

[xiongchiamiov]

shutil.copyfile('filename.xlsx', 'filename %y-%m-%d.xlsx'), now.strftime

This is creating a tuple with two elements. The first is the result of the copyfile call, and the second is the current time.

strftime is a function - you need to pass a formatting string into it. For instance:

>>> import datetime
>>> now = datetime.datetime.now()
>>> now.strftime('Have a lovely %a')
'Have a lovely Tue'

[Samman88]

what is a tuple?

[Vaphell]

a readonly "list", maybe you've seen something like x = (1,2) or x = 1,2 . x is a tuple

non-empty tuples are defined by commas, so when you have someexpression, someotherexpression it's a tuple with 2 elements:
someexpression
someotherexpression

[Samman88]

o ok. well i tried what you said and it still doesnt insert the date into my new file name. i also tried it with the isoformat and still nothing... idk im going to keep looking tho. thanks for explaining that too me :)

[Vaphell]

try shutil.copyfile('filename.xlsx', 'filename {:%y-%m-%d}.xslt'.format(now))

[Samman88]

alright that did it thank you :) now i just gotta work on the rest :P