DDiff from a date field to current date/now

[FollowTheData]

I used this formula to get days from creation to deactivation.

DDiff([Days in Client Last Deactivated On],[Days in Client Creation Date])

What formula can I use to obtain days from creation to current date/now?

I only have designer access to Sisense and do not have access to the data cube. 

[HamzaJ]

Hey @FollowTheData ,

You can use NOW() as a function in the formula. It does depend on your sisense version. Should work on Linux. I do think you will need to aggregate the formula max(ddiff())

Hamza