Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

Today's Date in Calculation / Snapshot Age

filipzahradnik

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

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

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

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!

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public