# Display Max(date) in a Text Box or KPI

**URL:** <https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431>\
**Category:** Q&A\
**Tags:** visuals, quick-sight\
**Created:** [January 25, 2023, 8:30pm UTC](https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431 "2023-01-25T20:30:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![TRube](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@TRube](https://community.amazonquick.com/u/TRube)\
**Post date:** [January 25, 2023, 8:30pm UTC](https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431/1 "2023-01-25T20:30:27Z")

</div>

I’m new to QS and this seems like it should be simple, but I can’t figure it out.

So I have a column that has the TimeStamp the data was loaded into the snowflake warehouse my spice dataset loads from.

I want to display a box at the top of my sheet that says “Data is current as of MM/DD/YYYY” where MM/DD/YYYY is the most recent date in the data set.

I have a calculated field for Max Load Timestamp. It works in a Table view. But is there a place where I can put that in elsewhere? like in a KPI Box or as part of a text box or even an insight? I couldn’t figure out how to do that in any other way that might look a little bit “prettier”

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [January 25, 2023, 9:04pm UTC](https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431/2 "2023-01-25T21:04:51Z")

</div>

You can do something like this.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/4/4988a239f45b653af51f8e183bb6d9f6a1ba4dac.png)

Substitute the latest\_refresh with your Max Load Timestamp.

Then you can create a maximum (or another calculation) but the maximum works and substitute in the Max Load Timestamp.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/36735345a82705a44fb6482f6f2d82d1a1109803.png)

Then after that you can use this in the insight and it should work.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/02f305007df4487844bc95cb18d7edf31c2860c5.png)

---

<div class="post-metadata">

**Author:** ![TRube](https://avatars.discourse-cdn.com/v4/letter/t/a88e57/32.png) [@TRube](https://community.amazonquick.com/u/TRube)\
**Post date:** [January 25, 2023, 9:44pm UTC](https://community.amazonquick.com/t/display-max-date-in-a-text-box-or-kpi/9431/3 "2023-01-25T21:44:29Z")

</div>

that worked, thank you!