Get date as month and year, but keep data type date

[Karolina]

Get date as month and year, but keep data type date as I need to sort by date, 
so using

format(<date>, "YYYY-MMM")

does not work as  this results in 2020-feb being before 2020-jan , which is of course not something desired.

How can I format the date so that it keeps the type as date, so that when sorting ascending it does not mess up?
alternatively how can I make a correct sorting using the format mentioned before?

[tex628 · Accepted solution]

You can change the display format of a date here:



Another way to do it is by doing what you're propsing with the FORMAT() but also creating a sorting column that sorts the initial year/month column.

Br,

J

[tex628 · Accepted solution]

You can change the display format of a date here:



Another way to do it is by doing what you're propsing with the FORMAT() but also creating a sorting column that sorts the initial year/month column.

Br,

J

[Karolina]

Thank you for your quick reply, that looks like it is what I'm looking for. But I cant find where to access that menu, could you explain that?

[tex628 · Accepted solution]

Select the column or measure that you want formatted from the menu on your right. Once it's highlighted you can then open the modelling section and open the format dropdown:



Br,
J

[Karolina]

Oh, selecting the column enabled a menu! thanks, although it is ont exactly the same so I will put it here:

Thanks again!
Br,
Karolina

[tex628]

My apologies, I'm jumping between versions a bit and i happened to be on an older version. But I'm glad you found it!

/ J