Finding the difference between dates

Get Help
1

Hello!

I'm trying to build a report without needing to use SQL.

What I am trying to achieve is showing me the number of days between the date a company was created (currently in format Month, D, YYYY) and the date the customer first placed an order (in the format Month, D, YYYY, HH:MM AM/PM).

But I can't figure it out. When I try to do a custom column it tells me the columns don't exist.

2

Hi there,

I believe datetimeDiff should work, but wondering if the error is because of something else. Could you share how you're writing this expression and a screenshot of the error? Also what DB engine you're using