Is there a way to reference today's date in a calculation? I am trying to create report showing age of snapshots (e.g. Today minus Access Time)
Ok, I worked it out:
1. Insert a calculation column
2. Edit the column as follows:
cast (current_timestamp, timestamp) - cast ([Access Time], timestamp)
3. Optionally, adjust data format for the Time interval type to hide miliseconds and seconds
Just what we were looking for. Took a little fumbling around to insert the cast statement but works like a champ and we found a few snaps that were a little older than we expected to see. - Thanks for the tip!