topic Today's Date in Calculation / Snapshot Age in Active IQ Unified Manager Discussions

Today's Date in Calculation / Snapshot Age

filipzahradnik — Thu, 05 Jun 2025 05:53:52 GMT

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

filipzahradnik — Tue, 17 Sep 2013 05:52:07 GMT

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

magurac_netapp — Tue, 17 Sep 2013 12:21:28 GMT

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!