Forum Discussion
error when trying to filter a datetime column
Hi ouafaa,
I have made a test try to reproduce your issue but every thing works well.
Did you have the same steps as mine?
Besides, you 'd better select the value from the table rather than enter the valur manually.
Best Regards,
Cherry
Hi v-piga-msft,
I did the same stapes. but got error.
and it works for another column table wich is in another table in the same database!
I still can't find the problem with this column
Hi,
I think I found the problem but I still can't solve it.
the problem is the format of my datetime column in the database dd/MM/yyyy hh:mm:ss
but for power bi, does not accept when i choose to filter by > 20/10/2008 00:00:00 for exemple, because for power bi 20 is not a valable month!
how can I tell to power bi that my datetime column has the format dd/MM/yyyy hh:mm:ss in my database ? before importing the data.
Thanks a lot for you help
Have you tried using the datetime syntax #datetime(yyyy, m, d, h, m, s)? For example, the date time syntax for 5/2/2018 9:52:00 PM is #datetime(2018, 5, 2, 21, 52, 0).
