Not sure if your experience was different, however I had to drop the .date off the following two statements to work correctly as the comparison wasn't returning true for Today. df['IsTodayFlag']=(df['Date'] == today).astype(int) df['IsToday'] = np.where(df['Date'] == today, 1, 0) Hope this helps - Chris Jones