Agrid filter for Date not filtering

[Sabariah_Suren]

Hi , the filter for the time and date isn’t working for me.
Can someone help me .

st.markdown(hide_menu,unsafe_allow_html=True)
file_upload = st.file_uploader('Upload file','.xlsx')

if file_upload is not None:
    df = pd.read_excel(file_upload)
    #st.checkbox("Use container width", value=False, key="use_container_width")

    #Installation Duration
    df['Installation_Actual_End'] = pd.to_datetime(df["Installation_Actual_End"])
    df['Installation_Actual_Start'] = pd.to_datetime(df["Installation_Actual_Start"])
    df['Installation_Duration'] = df["Installation_Actual_End"] - df["Installation_Actual_Start"]
    df["Installation_Duration"] = df["Installation_Duration"]
       
    df1 = df['Installation_Actual_Start','Installation_Actual_End','Integration']
    
    
    AgGrid(df1)```

[Upasana_Mittal]

did you find any solution to this issue?

[Henrique1]

For me, i had to convert the column i wanted to datetime first, df[‘date’] = pd.to_datetime(df[‘date’]) and before i star my GridOptionsBuilder.from_dataframe(df), if i did it after, it wouldnt work