dates = '2013-01-01', '2015-07-01'
date_from, date_to = [to_date(lit(s)).cast(TimestampType()) for s in dates]
sf.where((sf.my_col > date_from) & (sf.my_col < date_to))
datetime range filter in PySpark SQL