sysdate - 5 days

[sajan]

Hi,

I new to python.

I'm trying to make changes to an existing python code .
The code has an if condition something like

if datetime(*(time.strptime(creation_date, '%d-%b-%y')[0:6])) < datetime(2006,1,1):


now instead of using datetime(2006,1,1) on the right hand side of the if condition, I wish to have a variable that is (sysdate-5days )??

thanks for any help

[bartonc]

Hi,

I new to python.

I'm trying to make changes to an existing python code .
The code has an if condition something like

if datetime(*(time.strptime(creation_date, '%d-%b-%y')[0:6])) < datetime(2006,1,1):


now instead of using datetime(2006,1,1) on the right hand side of the if condition, I wish to have a variable that is (sysdate-5days )??

thanks for any help

Hello and welcome to the python forum. Here are some things to get you started:

>>> import datetime
>>> offsetTime = datetime.timedelta(-5) # negative 5 days

>>> varDate = datetime.date(datetime.MINYEAR,1,1)
>>> varDate = varDate.today()
>>> varDate
datetime.date(2007, 1, 5)
>>> varDate + offsetTime
datetime.date(2006, 12, 31)
>>>

[bvdet]

Maybe this will help:

>>> datetime.datetime(1,1,1).today() - datetime.timedelta(3)
datetime.datetime(2007, 1, 2, 8, 49, 30, 468000)
>>> print datetime.datetime(2007, 1, 2, 8, 49, 30, 468000)
2007-01-02 08:49:30.468000
>>> datetime.datetime(1,1,1).today() - datetime.timedelta(weeks=3)
datetime.datetime(2006, 12, 15, 8, 51, 3, 546000)
>>> print datetime.datetime(2006, 12, 15, 8, 51, 3, 546000)
2006-12-15 08:51:03.546000
>>> 

[bvdet]

More information that may be useful:

print '\nDifference between 2 datetime instances:'
creation_date = datetime.datetime(2006,12,31,0,12,44)
todays_date = datetime.datetime(1900,1,1).today()
target_date = datetime.datetime(1900,1,1).today() - datetime.timedelta(5)
 
print 'creation_date =', creation_date
print 'todays_date =', todays_date
print 'target_date =', target_date
 
print
print todays_date - creation_date
print todays_date - target_date
 
if creation_date > target_date:
    print "Greater"
elif todays_date < target_date:
    print "NOT Greater"
else:
    print "The dates are equal"

Output:

Difference between 2 datetime instances:
creation_date = 2006-12-31 00:12:44
todays_date = 2007-01-05 10:20:16.281000
target_date = 2006-12-31 10:20:16.281000
 
5 days, 10:07:32.281000
5 days, 0:00:00
The dates are equal

[bvdet]

if creation_date > target_date:
    print "Greater"
elif todays_date < target_date:
    print "NOT Greater"
else:
    print "The dates are equal"

Oops! Should be:

if creation_date > target_date:
    print "Greater"
elif creation_date < target_date:
    print "NOT Greater"
else:
    print "The dates are equal"