DB View Calculate difference between dates and add to third date field.

[gsh1]

Hi all,

We have a requirement where we have to show some date calculation in a report.

We have created a database view between two tables, now requirement is to calculate the difference between two Date time field and add it to the third date time field in this case it is SLA breach time.

Date difference I am calculating by creating function field and datediff function.

How do I add that difference in to third date time field and show on report

[Ankur Bawiskar]

@gsh1 

you said you already created a function field and storing the difference.

then why not show that function field on report?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[gsh1]

Hi Ankur,

Thanks for your message how to add that difference in third date time field and show in report.

Refer screenprint if that helps.