Format for Year in Date Table

I’ve noticed that when a date is split into a year column, that most seem to format the year (e.g. 2019, 2018) as text instead as a whole number.

Does it make any difference in the data models if it is formatted as a whole number?

Regards, Sergei

Just depends really I think.

Most of the time probably doesn’t matter, but say for example you have a year column in a fact table, you probably want to have them setup the same.


1 Like