Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datediff between two tables no relationship

Hi Experts

 

is it possile to work out the difference in datas between two dates in two different tables no direct releationship.

 

Need Help
  • az38's avatar
    az38
    6 years ago

    Anonymous 

    it depends on your data model. if you could provide exactly matching via LOOKUPVALUE() function or if somenthing LIKE FIRSTNONBLANK() or any aggregation functions like MIN() or MAX() will ensure enough quality for your business logic you will be able to do DATDIFF() easily

3 Replies

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    Anonymous 

    it depends on your data model. if you could provide exactly matching via LOOKUPVALUE() function or if somenthing LIKE FIRSTNONBLANK() or any aggregation functions like MIN() or MAX() will ensure enough quality for your business logic you will be able to do DATDIFF() easily

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Super user 2

      here is an image of my model....trying to do datediff between tabel A (_duedate) and table b (approveddate)