Solved: Today's Date in Calculation / Snapshot Age

filipzahradnik · ‎2013-09-16

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

filipzahradnik · ‎2013-09-16

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

filipzahradnik · ‎2013-09-16

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 · ‎2013-09-17

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!