
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Associate Date as a key
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, Just ensure that the fields are named the same. Depending on the use case will determine if it is best practice or not.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
