Active IQ Unified Manager Discussions

Today's Date in Calculation / Snapshot Age

filipzahradnik
3,361 Views

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

1 ACCEPTED SOLUTION

filipzahradnik
3,361 Views

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

View solution in original post

2 REPLIES 2

filipzahradnik
3,362 Views

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

magurac_netapp
3,361 Views

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!

Public