This allows you to just call excel_date and it will convert any dates between excel and python datetime.
1 2 3 4 | def excel_date(value):
value = float(value) - 2
edate = datetime.datetime(year=1900,month=1,day=1)
return edate + datetime.timedelta(days=value)
|
More like this
- Template tag - list punctuation for a list of items by shapiromatron 9 months, 1 week ago
- JSONRequestMiddleware adds a .json() method to your HttpRequests by cdcarter 9 months, 2 weeks ago
- Serializer factory with Django Rest Framework by julio 1 year, 4 months ago
- Image compression before saving the new model / work with JPG, PNG by Schleidens 1 year, 4 months ago
- Help text hyperlinks by sa2812 1 year, 5 months ago
Comments
You could explain input and output values. Example?
#
Please login first before commenting.