Associate Date as a key

[teruru]

Can I use the column of date as a key?

I wanna associate two tables with date column as a key.
Can I do this?

[BrunPierre]

For example, if you have a Sales table and a Calendar table, both with a date field, you can associate them using the date field. This allows you to analyze sales data based on calendar information (e.g., sales by day, month, quarter, etc.)

[Mark_Little]

Yes, Just ensure that the fields are named the same. Depending on the use case will determine if it is best practice or not. 

[teruru]

Thank you for reply.

I associate the data field with the same name, but the data was change the same data .

dateA : from 2023/01/01 to 2024/01/01

dateB: from 2023/04/01 to 2023/06/01

these date field change all dataA.

Do you know the reason why?

[teruru]

Thank you for reply.

I associate the data field with the same name, but the data was change the same data .

dateA : from 2023/01/01 to 2024/01/01

dateB: from 2023/04/01 to 2023/06/01

these date field change all dataA.

Do you know the reason why?