Community

Subscribe
Highlighted
Accepted Solution

Today's Date in Calculation / Snapshot Age

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)

Thanks,

Filip

Re: Today's Date in Calculation / Snapshot Age

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

Re: Today's Date in Calculation / Snapshot Age

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!