Forum Discussion
Create column based on difference between two dates from two tables
Swiftglade
I suggest you avoid creating Many-to-Many relationships. If you can share the formula, it will be clear enough.
Hi Fowmy ,
Many to Many relationship comment-
I will look into cleansing the data, but we recieve it with values that have duplicates, from Receipt ID to another version of Receipt ID. At the moment, we cannot cleanse it and must have it as Many-Many.
Formula-
We are trying to get the First Date from "Final Merger", and compare the date to Export Worksheet.
So for example, We have "Frist Date, which is June 23. We want to know the when the next workday is,
so we created a column in our Date Table to have the next work day.
We then want to compare if the date the product was received (Second Date) is on time or not on time.
Our goal was to do an Greater than if statement.
Another example below.
IF(Second Date>Next Workday),"Shipment has passed date","Shipment was received on time")
| Final Merger | Export Worksheet | |
| First | Inventory Stored | Next Workday |
| 2021-02-10 0:00 | 2021-02-11 0:00 | 2021-02-11 0:00 |