Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Datediff between date and minimum date

Hi,   I have two tables. First table contains workorder information. Second table contains material transations information. Join is on workorder ID and operation sequence number. I try to compare ...
Need Help
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Anonymous 
can you provide the sample data for both the tables??
would be easier for us to give you proper answer.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    No sorry, it is confidential information.

    • Uzi2019's avatar
      Uzi2019
      Community Champion
      2 years ago

      Hi Anonymous 
      No problem.

      Can you provide the just sample data take same no of columns and change the values of a columns. And share both the files just screen shot of 4 to 5 records.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi, see both tables for an example. Join_ID 5465083-100 can be used as an example. Once listed in the first table, multiple times in the second (transaction table). Outcome should be days difference between the minimum transaction date of the second table and the release date of the first table, by Join ID. Thanks in advance