This isn't the only way, but I believe a good way to handle this issue...I'll try to explain my approach backwards - probably make more sense that way:If indeed you do need a string for the date in the SQL query, then I think you should replace the following line (and supporting lines of code in your def function) in order to make a more reliable one that can produce a correct date string (e.g., '2001-31-05').strFromDate = "'" + strFYear + "-" + strDay + "-" + strMonth + "'"Probably best to 'intercept' what is being passed into the function and replace it with a 'time object' - see this simplified version below (all of the following that I'm doing is tested via IDLE):
>>> import time
>>> def x(Start_Date):
strFromDate = time.strftime("%Y-%d-%m", Start_Date)
strWhere = "qryELM.elmPK = tblELM.elmPK AND dbo.tblELM.LoggedDate >= '" + strFromDate + "' AND dbo.tblELM.EnquiryFK IN (4,22,25,61)"
return strWhere
The Start_Date param that is passed in is what I call the time value object (rather than a string)...consider the following where I'm preparing your 2 values with the time module's strptime (I suppose this part could be part of the function, but wanted to show passing into the function an object and keep it similar to your function):
>>> # Your 1st date as 3 variables, type integer:
>>> day, mon, year = 1, 1, 2001
>>> print day, mon, year
1 1 2006
>>> # converted to 'concatenated' space-delimited string:
>>> strDate = '{0} {1} {2}'.format(day, mon, year)
>>> print strDate
1 1 2006
>>> # the string converted to time.struct obj
>>> objYourDate1 = time.strptime(strDate, '%d %m %Y')
>>> print objYourDate1
time.struct_time(tm_year=2006, tm_mon=1, tm_mday=1, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=6, tm_yday=1, tm_isdst=-1)
>>> # Your 2nd date as 3 variables, integer, etc. etc. (no further comments necessary):
>>> day, mon, year = 31, 5, 2001
>>> print day, mon, year
31 5 2001
>>> strDate = '{0} {1} {2}'.format(day, mon, year)
>>> print strDate
31 5 2001
>>> objYourDate2 = time.strptime(strDate, '%d %m %Y')
>>> print objYourDate2
time.struct_time(tm_year=2001, tm_mon=5, tm_mday=31, tm_hour=0, tm_min=0, tm_sec=0, tm_wday=3, tm_yday=151, tm_isdst=-1)
And finally, using the new def function by 'mining' or converting the objs with the alternate time module's strftime - which should always return the correctly formatted date string:
>>> x(objYourDate1)
"qryELM.elmPK = tblELM.elmPK AND dbo.tblELM.LoggedDate >= '2006-01-01' AND dbo.tblELM.EnquiryFK IN (4,22,25,61)"
>>> x(objYourDate2)
"qryELM.elmPK = tblELM.elmPK AND dbo.tblELM.LoggedDate >= '2001-31-05' AND dbo.tblELM.EnquiryFK IN (4,22,25,61)"
Hope that helps... if not clear, let me know.Enjoy,Wayne...oh and by the way, this Python reference was extremely useful:http://docs.python.org/2/library/time.html#time.strftime
