DatetimeDiff with Min([Date]) & Now()

Get Help
1

I'm getting an error when trying to get an aggregate difference in days between a date and now. My want is to incorporate into a pivot view that will show difference in days as you navigate hierarchy (e.g. State > City > Zip Code).

This is the formula I'm using: =datetimeDiff(Min([date]),now(),"day")

image

2

I've figured out what I need to do...

I did a Min on the actual date itself and then did the custom expression = Max(datetime([date],now(),"day") to accomplish what I needed.