Dates Day/Month only

Hi all,
I have a few tables that have data by year in each column. I want to show the information over a set time period for each of those years. I have a standard date table but don’t have a column that just shows the date and month only e.g. DD/MM. I have tried a column by example to split my DD/MM/YY column but it has this as text- and if i change to a date function it then adds back the year.

Is there a way to add a new column to my date table that just shows DD/MM and not year?

Thanks in advance.


Here’s a very short video demonstrating how to set custom date formats. Should be able to set your day/month format easily using this approach.

  • Brian

Thanks Brian- Perfect!