anvil.tables.TableError: Column 'date' is a datetime - cannot set it to a simpleObject

Anvil Q&A
1

Hi, I get above error when adding row to data table from self.date_picker_1
How should I solve this?
Thanks,

2

There’s some detective work involved in most problems like this. It would help to be able to see the scene of the crime, er, the actual code that’s producing the error.

3

@p.colbert
here is the code:

   def button_1_click(self, **event_args):
    """This method is called when the button is clicked"""
    new_row = app_tables.exp.add_row(date= self.date_picker_1, item=self.tex_box_item, 
                                     category=self.drop_down_category, value= self.text_box_value)
    ```
Thanks,
4

[quote=“m.iravani, post:3, topic:6205”]
solved by amending

date= self.date_picker_1

to

date= self.date_picker_1.date

Thanks,

1 Like