Problems with date

[Bergh]

Hi. I have a problem with dates. I have a column called plstart, this contains decimal numbers. This tells when a detail should start to be produced. This is connected to a workplace-table which  is connected to a calendar-table. This calendar contains similar columns with numbers but no one is exact. "Planned start time in relative time depending on calendar" it says as a comment. How do I?

 

[v-yiruan-msft · Accepted solution]

Hi @Bergh ,

Based on your description, it seems that you want to connect the timestamp-like column plstart in the Workplace table with the retime column in the Calendar table. But the problem is that the column plstart does not have exactly the same information as retime, so you may not get the data. Am I understanding this correctly? Please correct me if it is not correct. Also, could you please share some sample data withText format (exclude sensitive data) and the final result you want in order to analyze and provide you with a suitable solution.

1. Sample data with Text format

Col1	Col..	Colx
xx	xx	xx
xx	xx	xx

2. Your expected result?? A table visual or something else?

Best Regards