How to get the latest date of existing data

[Anonymous]

Hi,

i get a different dates from tables like

01.01.2016

01.02.2016

01.03.2016

How can i get the latest date of existing data?

regards,

sam

[swuehl]

If your dates are interpreted as dates and read in as duals, try

=Max(DATEFIELD)

or

=Maxstring(DATEFIELD)

Get the Dates Right

Why don’t my dates work?

[Anonymous]

Hi.

the latest date i have is 30.11.2016.

I try Max and Maxstring and get 31.12.2016.

But the result must be 30.11.2016.

regards,

sam

[sunny_talwar · Accepted solution]

May be like this:

Max({<Measure= {'*'}>}Date)

Measure can be any field which is available in your fact table.

[Anonymous]

I get an error message: "Wrong fieldname: Date"

Is Date like "Measure" a placeholder or a function?

[sunny_talwar · Accepted solution]

Its a placeholder for a field from your fact table. and Date is a placeholder for your date field

[Anonymous]

ah ok, now it works, thank you 🙂

[swuehl]

s Walter wrote:

Hi.

the latest date i have is 30.11.2016.

I try Max and Maxstring and get 31.12.2016.

But the result must be 30.11.2016.

regards,

sam

Seems like there is some context missing.

Please explain your data model and your requirement.