Problems with date format with AG grid and dcc.store

I’m having trouble with the date conversion from dataframe to dict in AG grid and dcc.store.
for example: the date column of my dataframe, is converted to this format in the AG grid
2023-05-12T00:00:00 .

Is there an option for loading the AG grid or dcc.store with the correct date format ?

There’s a workaround:
in your dataframe convert the type of your date column to string type and try.

2 Likes

Thank you Justin, it works perfectly for me

df[‘Date’]=df[‘Date’].astype(str)

1 Like

But with this workaround it is not possible to filter this column with ‘agDateColumnFilter’ anymore…

Hi @Loris

This example in the docs might be helpful:

1 Like