Question

How to print all dates between two dates in Python

Answer 1

from datetime import date, timedelta

startdt = date(2020, 6, 27) 
enddt = date(2020, 7, 27)   

delta = enddt - startdt      

for i in range(delta.days + 1):
    day = startdt + timedelta(days=i)
    print(day)



  
'''
run:
   
2020-06-27
2020-06-28
2020-06-29
2020-06-30
2020-07-01
2020-07-02
2020-07-03
2020-07-04
2020-07-05
2020-07-06
2020-07-07
2020-07-08
2020-07-09
2020-07-10
2020-07-11
2020-07-12
2020-07-13
2020-07-14
2020-07-15
2020-07-16
2020-07-17
2020-07-18
2020-07-19
2020-07-20
2020-07-21
2020-07-22
2020-07-23
2020-07-24
2020-07-25
2020-07-26
2020-07-27

'''

 

70+ SQL courses for beginners and professionals

Answer 2

from datetime import date, timedelta
import pandas as pd 

startdt = date(2020, 6, 27) 
enddt = date(2020, 7, 27)   

lst = pd.date_range(startdt, enddt - timedelta(days=1), freq='d')

print(lst)



  
'''
run:
   
DatetimeIndex(['2020-06-27', '2020-06-28', '2020-06-29', '2020-06-30',
               '2020-07-01', '2020-07-02', '2020-07-03', '2020-07-04',
               '2020-07-05', '2020-07-06', '2020-07-07', '2020-07-08',
               '2020-07-09', '2020-07-10', '2020-07-11', '2020-07-12',
               '2020-07-13', '2020-07-14', '2020-07-15', '2020-07-16',
               '2020-07-17', '2020-07-18', '2020-07-19', '2020-07-20',
               '2020-07-21', '2020-07-22', '2020-07-23', '2020-07-24',
               '2020-07-25', '2020-07-26'],
              dtype='datetime64[ns]', freq='D')

'''

 

70+ SQL courses for beginners and professionals

Answer 3

from datetime import date, timedelta
import pandas as pd 

startdt = date(2020, 6, 27) 
enddt = date(2020, 7, 27)   

lst = pd.date_range(startdt, enddt - timedelta(days=1), freq='d')

for dt in lst: 
    print(dt.year,"-",dt.month,"-",dt.day) 



  
'''
run:
   
2020 - 6 - 27
2020 - 6 - 28
2020 - 6 - 29
2020 - 6 - 30
2020 - 7 - 1
2020 - 7 - 2
2020 - 7 - 3
2020 - 7 - 4
2020 - 7 - 5
2020 - 7 - 6
2020 - 7 - 7
2020 - 7 - 8
2020 - 7 - 9
2020 - 7 - 10
2020 - 7 - 11
2020 - 7 - 12
2020 - 7 - 13
2020 - 7 - 14
2020 - 7 - 15
2020 - 7 - 16
2020 - 7 - 17
2020 - 7 - 18
2020 - 7 - 19
2020 - 7 - 20
2020 - 7 - 21
2020 - 7 - 22
2020 - 7 - 23
2020 - 7 - 24
2020 - 7 - 25
2020 - 7 - 26

'''

 

70+ SQL courses for beginners and professionals