Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Create a text box with
=max(date)
-Sundar
Dear Benjamin
See the Attachment
Regards
Aviral Nag
Create A variable Called
vMaxDate=Max(Date)
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()
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!
Hi, thanks for all the idea.
Regards
Benjamin See