Forum Discussion
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.
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
az38
Community Champion
Community ChampionAnonymous
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
Hi Super user 2
here is an image of my model....trying to do datediff between tabel A (_duedate) and table b (approveddate)