Dateformat not right in table

[Frixel]

Hello,

I have a trouble to get the right date format in my model.

If you see in the query the dateformat is "8-1-2023" but in the model it is "zondag 8 januari 2023"

How can i change the date format in the model also to 8-1-2023?

[Idrissshatila · Accepted solution]

Hello,

try clicking at the date column and format it from the column formatting the format you want.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Frixel]

@Idrissshatila 
Thanks for yoyr quickly answer 😀

i have only this window if i rightclick there.

[Frixel]

YES, i find it.

It is NOT in the qurey but in the tab in the model.

Thanks for your helps