Date sorting by month

[111182]

Hello everyone, 

I'm having problem that in UX I can only sort date by daily date like 27/4/2022 - 28/4/2022

I'm trying to find away to make sorting by month like making group for April then I can see each day data inside April section. 

Any ideas about how to make so ? 

[Rafael_ANEIC-PY]

Hello @111182, you can use the "Group by" option in the configuration of the view you wish to have the rows grouped, you just have to select the date column, this can be complemented by sorting using the dates using the "Sort by" option.

[mateo]

Probably you have only one column with TimeLog. You can create virtual columns [MONTH] and [DAY] where you will be retrieving values from your original [TimeLog] column. That is all I can say regarding provided information. If it doesn't work give us more info to dive deeper. 

[111182]

i will try this method I think its the way I want

[graham_howe]

You could create a virtual column which has the month calculated from the daily date field. Then group by that month field in your view.

[111182]

can you explain that with steps please