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.