Best way display single Date?

[#1]

Hi,

I have a list of date, and i just need to pick the max(date) in on top of the sheet as an object.

The date will as like latest data date on my report.

What is the best way to do it? Thanks.

Regards

Benjamin See

[sundarakumar · Accepted solution]

Create a text box with

=max(date)

-Sundar

[aveeeeeee7en]

Dear Benjamin

See the Attachment

Regards

Aviral Nag

[#4]

Create A variable Called

vMaxDate=Max(Date)

[#5]

i think u want show What is latest Reload time of your data then u can

use following text in Text Box

it will give latest Reload time

='The Latest Reload Time is  

'& ReloadTime()

[greg-anderson]

Hi, Benjamin.  I agree with what has been stated- create a variable in script that grabs the max(date) after the relevant data is loaded.

One word of caution with date variables: beware of the format of the stored value.  I use many date-related variables in my reporting.  When I look at these variable values through the QV menu, I see (for example) '2/26/2014' for Today().

If I try to use this date for comparison QV will sometimes process it as an arithmetic fraction (2 / 26) / 2014.

For this reason, I store all date values as Num(date), if I'm actually storing the date rather than a text representation of it.  Then I can extract anything I need and format the date in any way I choose without worrying about ambiguity in comparative analyses.

I know there are other ways around this, but this one works best for me.  Cheers! 

[#7]

Hi, thanks for all the idea.

Regards

Benjamin See